Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “grama” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

108 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
grama8562028(None) 
drama85117421drama
gama77035521g_ama
gram77034581gram_
gramas94317201gramas
gramma11499801gramma
gramp106218321gramp
grampa115010171grampa
grams85327311grams
grana65722091grana
agama85815582agama
ama510853302__ama
arame75026622arame
aroma71220142aroma
asrama839192asrama
brahma1336192brahma
brava106414792brava
braza165214252braza
cram85635492cram_
cramp115120692cramp
crams96229152crams
dram75832002dram_
dramas95814662dramas
drams86025832drams
frame105821802frame
gaga66625552g_aga
gala55635162g_ala
gam67060062g_am_
gamas85431362g_amas
gamay116419112g_amay
gamb96331842g_amb
gamba106018512g_amba
game76644322g_ame
gamma106116102gamma
gamp98833212g_amp
gams76648882g_ams
gamy105427532g_amy
garda7316762garda
gemma106311772gemma
glam76529342glam_
glams85822932glams
graal64316502graal
grab75427612gra_b
grabs85719692grabs
grace85124542grace
grad66829862gra_d
grade75126092grade
grads75625752grads
graft95327202graft
graham1237852graham
grail64622872grail
grain65126252grain
gramary1355912gramary
grammar12406892grammar
grammas12499772grammas
gramme114210332gramme
grampas12399252grampas
gramps114114272gramps
gran56335012gra_n
grand75122692grand
grandma1136912grandma
grans64832542grans
grant64840022grant
grape84824662grape
graph115315612graph
grappa11396442grappa
grapy115416432grapy
grasp84814482grasp
grass66125202grass
grat55651282gra_t
grate64932882grate
grave94624872grave
gravy125512112gravy
gray85329892gra_y
grays95621332grays
graze155820052graze
grim76929422grim_
grime85021322grime
grimy114312602grimy
grum75625082grum_
grume86218162grume
grump105115312grump
guava938582guava
gumma105313102gumma
karma113415012karma
lama66635292_lama
llama799892llama
mama86231592_mama
praam94815612praam
pram85733492pram_
prams96125512prams
prima95019342prima
raga55930812_raga
raia46638382_raia
raja117918682_raja
ram56867272_ram_
ramal74622242_ramal
rami66034092_rami
ramp85934002_ramp
rams65950772_rams
raya75224822_raya
tarama8412732tarama
tram67034552tram_
tramp96319772tramp
trams75327672trams
trauma838802trauma
tryma1037222tryma
ulama7711472ulama

Search took 2 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter178691538000.313570897.8
2DLD Change Limit538001081.45337026.8
3Display Results1081080.0303600.0
 (SQL Overall)1786911081.79699493.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.