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 “gremmy” with Change Limit: [1] [2] [3]

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

269 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
gremmy145447(None) 
gemmy135211051g_emmy
creamy134811362creamy
crummy15365892crummy
dreamy12509992dreamy
emmy116013242__emmy
gammy135514892g_ammy
gemma106311772g_emma
germy115113662g_ermy
gleamy12398112gleamy
gramma11499802gramma
gramme114210332gramme
greasy10419462greasy
greedy11518842greedy
greeny104811452greeny
gremmie1264382gremmie
grey85624042gre__y
greyly13316542greyly
grimly12459932grimly
grimy114312602gr_imy
grumpy14498152grumpy
gummy135413652g_ummy
jemmy19498552_jemmy
rammy124312492_rammy
rummy124212412_rummy
stemmy13417032stemmy
army96624183ar__my
beamy126218573_beamy
bready124511183bready
bream95121813bream_
breams104815043breams
breezy20295853breezy
bregma1134963bregma
broomy13449953broomy
brumby15385953brumby
chammy18488953chammy
chummy18385893chummy
clammy15356333clammy
commy144712643_commy
crampy154710993crampy
creaky154911553creaky
cream95721343cream_
creams104715253creams
creasy114612303creasy
creepy13418803creepy
creme94319323cre_me
cremes104517993cremes
crepey135110933crepey
crepy124812703cre_py
cressy11439113cressy
crimpy15489393crimpy
crumby15408113crumby
demy105422853_de_my
dream85120393dream_
dreams94513983dreams
dreamt94615713dreamt
dreary104611673dreary
drecky16486333drecky
dreggy12364633dreggy
dressy10518143dressy
drumly1235703drumly
dummy134712783_dummy
elmy95616793__elmy
emmys12446023__emmys
enemy1059993ene_my
femme125011433_femme
freaky16439233freaky
freely12310953freely
fremd115010323fre_md
frenzy2135883frenzy
fretty1249223fretty
frumpy16466883frumpy
gamay116419103g_amay
gamely124711913gamely
gamey115320553g_amey
gamma106116103g_amma
gamy105427533g__amy
geeky134710733g_eeky
gem66840223g_e_m_
gemmae11507793g_emmae
gemmed12329573g_emmed
gemmily1534603g_emmily
gemot84024233g_emot
gems75329113g_e_ms
germ75428963g_erm_
german9611983german
germen9612313germen
germs85118873g_erms
geum75424553g_eum_
geums85414113g_eums
gey75738303g_e__y
gimme102411343g_imme
gimpy135212233g_impy
gleam86916733gleam_
gleams94812253gleams
gleety10479193gleety
glegly1134873glegly
gley85724653gle__y
gloomy12528763gloomy
glumly12356623glumly
glumpy14527193glumpy
grabby14336183grabby
grainy103914213grainy
gram77034583gr_am_
grama85620283gr_ama
gramary1355903gramary
gramas94317203gramas
grammar12406893grammar
grammas12499773grammas
grammes123611323grammes
gramp106218323gr_amp
grampa115010173grampa
gramps114114273gramps
grams85327313gr_ams
granny104311163granny
grapey126012303grapey
grapy115416433gr_apy
grassy10619093grassy
gravy125512113gr_avy
gray85329893gr__ay
grayly13287963grayly
grease75416233grease
great66034243gre_at
greatly1137613greatly
greats76318393greats
greave104611493greave
grebe85114943gre_be
grebes93813613grebes
gree56641563gre__e
greed75125693gre_ed
greeds84314283greeds
greek105915943gre_ek
green65522143gre_en
greenly11408183greenly
greens75716873greens
grees65132473gre_es
greet65835323gre_et
greets75117423greets
grego7310523gre_go
gregos847533gregos
greige847203greige
gremial1039153gremial
gremlin1035563gremlin
gremmies1355993gremmies
grew85620263gre__w
greyed114610603greyed
greyer104510093greyer
greys96614853gre_ys
grim76929423gr_im_
grime85021323gr_ime
grimed104714093grimed
grimes94619033grimes
grimily1336523grimily
grimmer123510093grimmer
gripey124111203gripey
grippy14447763grippy
gripy115115253gr_ipy
grisly104310583grisly
gritty10338403gritty
grody103412063gr_ody
groggy1234803groggy
grommet12268453grommet
groom85317983groom_
grooms94512523grooms
groovy13375403groovy
groszy19395703groszy
grotty10389833grotty
grouty104710983grouty
growly13499173growly
grubby14324503grubby
gruffy16396013gruffy
grum75625083gr_um_
grumbly15355403grumbly
grume86218163gr_ume
grumes94415553grumes
grummer12338783grummer
grummet12298873grummet
grump105115313gr_ump
grumphy18443623grumphy
grumps114510573grumps
grungy11345973grungy
gumma105313103g_umma
hammy155113433_hammy
hempy154912763_hempy
immy114611823__immy
jammy194810193_jammy
jimmy19538503_jimmy
lemma94811033_lemma
mammy115215163_mammy
maremma1044463maremma
maremme1054603maremme
mommy114010753_mommy
mummy114913623_mummy
plummy15375663plummy
pommy14449863_pommy
preamp1238993preamp
prebuy1357423prebuy
predry1237863predry
preman104117453preman
premed114617753premed
premen105017803premen
premie103617993premie
premix173710333premix
prepay13310313prepay
preppy1235523preppy
pretty11510873pretty
prexy174611573pre_xy
prey96228483pre__y
primly13439623primly
ready94821503_ready
ream65841613_ream_
reams75729623_reams
rebuy104714683_rebuy
redly94217193_redly
redry94314363_redry
reedy910020283_reedy
reefy114217703_reefy
reeky125416263_reeky
refly113914563_refly
refry114412463_refry
regma84612333_regma
reify114814973_reify
rekey124014733_rekey
relay84424673_relay
rely75428953_re_ly
rem56150043_re_m_
reman75730153_reman
remap95418103_remap
remedy1237863_remedy
remet74843723_remet
remex146315793_remex
remit75737223_remit
remix145916553_remix
rems66237723_re_ms
repay104818453_repay
reply104015853_reply
resay85320543_resay
retry84718083_retry
rheumy1433353rheumy
rimy96621283_r_imy
roomy107118063_roomy
scummy15265223scummy
seamy105921273_seamy
seemly1138433seemly
shammy16388503shammy
shimmy16306413shimmy
slummy13325863slummy
steamy115112373steamy
stemma10328133stemma
streamy12509483streamy
swimmy16234353swimmy
tammy124013223_tammy
termly1138433termly
thrummy1742173thrummy
tommy124712233_tommy
trampy13499253trampy
treaty94414353treaty
trebly1138973trebly
trembly1435523trembly
tremor84210393tremor
trendy10469603trendy
tressy9448553tressy
trey77228793tre__y
trimly114410893trimly
tummy124711993_tummy
uremia82910893uremia
uremic103410513uremic
whammy19375293whammy
yummy15429153_yummy

Search took 8 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 Filter1786911127160.186960704.3
2DLD Change Limit1127162696.95316211.1
3Display Results2692690.0932892.5
 (SQL Overall)1786912697.23224708.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.