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 “grotto” 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.

291 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
grotto734981(None) 
grottos8337331grottos
grotty10389831grotty
arnotto7134732arnotto
blotto8198442blotto
garotte868702garotte
ghetto1036072ghetto
gritty10338402gritty
groat65531972groat_
groats74816652groats
grot55942052gro_t_
grots65025852gro_ts
grottoed10234502grottoed
grottoes9276752grottoes
grout65330422grout_
grouts75015612grouts
grouty104710982grouty
growth1377382growth
lotto55217572_lotto
motto76119512_motto
otto45220642__otto
potto75320942_potto
pronto8313992pronto
roto45935052_ro_to
rotte54625932_rotte
anatto6139913anatto
aristo6414033aristo
arnatto7145073arnatto
arnottos8163853arnottos
blotty11178343blotty
bott66548573_bott_
bottom1048723_bottom
botts75224863_botts
bratty1159683bratty
britt75732233britt_
britts84813443britts
bromo95217203bro_mo
bronco10179493bronco
broo65129823bro__o
broth106521093bro_th
broths115013923broths
brothy14519623brothy
chott103923933chott_
chotts113610993chotts
clotty11208263clotty
conto76027173_conto
cotta75818573_cotta
cotton8312993_cotton
croft105622683croft_
crofts114910593crofts
crotch133410083crotch
croton84415453croton
croute84617273croute
crouton947133crouton
crypto13367273crypto
datto65416423_datto
ditto65315603_ditto
dotty94516103_dotty
droit65127123droit_
droits74314313droits
drongo836793drongo
dropt86924433dropt_
drouth104410103drouth
erotic82620273erotic
fretty1249223fretty
fritt86129413fritt_
fritts94613193fritts
front85029223front_
fronton1037203fronton
fronts94415793fronts
frost84727833frost_
frosts94214623frosts
frosty124710633frosty
froth115919283fro_th
froths125411443froths
frothy15578373frothy
garote7717953garo_te
garoted9710133garoted
garotes8614563garotes
garotted1066193garotted
garotter965943garotter
garottes978283garottes
garrotte965683garrotte
gavotte1174603gavotte
gelato73812953gelato
gentoo7311313gentoo
ghettos1134473ghettos
ghost96318763ghost_
ghosts10489273ghosts
ghosty13467213ghosty
gloat65427683gloat_
gloats74515423gloats
glost65422933glost_
glosts74513813glosts
glottal835103glottal
glottic1036653glottic
glottis837173glottis
glout65925813glout_
glouts74414713glouts
glutton844893glutton
gnatty10336483gnatty
goat56250833g_oat_
goats65527303g_oats
gobo76126903g_o_bo
gogo69722833g_o_go
gombo105814043g_ombo
gonzo15310243g_onzo
goo47754773g_o__o
got49870443g_o_t_
goth86825083g_o_th
goths96513003g_oths
gotten73410113g_otten
gout56646003g_out_
gouts64826173g_outs
gouty95217363g_outy
graft95327203graft_
grafts105013253grafts
grant64840023grant_
grantor84010933grantor
grants73722473grants
grat55651283gr_at_
grate64932883gr_ate
grated84523923grated
grater74625443grater
grates75429893grates
gratin74520583gratin
gratis74819243gratis
great66034243great_
greats76318393greats
greet65835323greet_
greets75117423greets
grego7310523gr_ego
grift95924463grift_
grifts104511683grifts
gringo838643gringo
griot65328413griot_
griots74713643griots
gript85126173gript_
grist65529873grist_
grists74716483grists
grit55247243gr_it_
grith95520373gr_ith
griths105211653griths
grits65529583gr_its
gritted94110903gritted
gritter83913353gritter
groan65618423gro_an
groans74815063groans
grocer94212143grocer
grody103412063gro_dy
grog65923343gro__g
groggy1234803groggy
grogs76319413gro_gs
groin65521083gro_in
groins73917203groins
grok95819683gro__k
groks105716123gro_ks
groom85317983gro_om
grooms94512523grooms
groove10438873groove
groovy13375403groovy
grope84821613gro_pe
groped107515053groped
groper94517253groper
gropes95220403gropes
gross65421693gro_ss
grosz154814093gro_sz
grosze16457733grosze
groszy19395703groszy
grottier9316673grottier
grouch12318473grouch
ground82310273ground
group85413923gro_up
groups94210513groups
grouse74315023grouse
grouted94111503grouted
grouter84412523grouter
grove95219333gro_ve
groved114413703groved
grovel104310543grovel
groves104318103groves
grow86127303gro__w
grower104614933grower
growl96115823gro_wl
growls104711113growls
growly13499173growly
grown95317353gro_wn
grows95523923gro_ws
growths1494423growths
growthy1773283growthy
groyne1037213groyne
grunt65523543grunt_
grunts75511853grunts
grutch12285563grutch
grutten885283grutten
gusto65414643g_usto
gutta64613383g_utta
gutty94516993g_utty
iroko939663iro_ko
jotty155012603_jotty
knotty13315223knotty
koto86323473_ko_to
lotte54923853_lotte
lottos64613103_lottos
molto75619603_molto
mott66648443_mott_
motte75526973_motte
mottos84615243_mottos
motts76527003_motts
onto46127663__onto
ortho8312293or_tho
ottos54714323__ottos
petto76021043_petto
photo104417233pho_to
plotty11208853plotty
potato8513433_potato
pottos84615873_pottos
potty105621003_potty
presto84216203presto
pretty11510873pretty
proctor11310433proctor
proette9312363proette
promo95620003pro_mo
proso77222413pro_so
prost75434103prost_
protea82214763protea
protei82615313protei
proton84318893proton
protyl11308213protyl
prutot8311823prutot
putto75617663_putto
ratio55227583_ratio
rato45436973_r_ato
ratton64116123_ratton
ratty84819593_ratty
recto74520803_recto
retro55020953_retro
ridotto844323ridotto
risotto744323risotto
robot7325973_robot
rodeo65921093_rodeo
romeo73719703_romeo
rondo65218373_rondo
root45655923_root_
roots55933673_roots
rooty86423023_rooty
rot37282953_ro_t_
rota45834343_ro_ta
rotas54827723_rotas
rotate63320343_rotate
rotator7310833_rotator
rotch105815933_rotch
rote46249023_ro_te
rotes56143903_rotes
roti46332933_ro_ti
rotis56327063_rotis
rotl45029683_ro_tl
rotls55620163_rotls
rotor55519733_rotor
rotos56027883_rotos
rots46454093_ro_ts
rotted74524433_rotted
rotten64115433_rotten
rotter64325463_rotter
rottes64524833_rottes
rout46153283_rout_
route55132073_route
routh86423073_routh
routs57133413_routs
rowth115713233_rowth
rutty85617803_rutty
shott85332193shott_
shotts93614703shotts
snotty9489203snotty
spotty11448583spotty
stott56929793stott_
stotts64612863stotts
stretto737733stretto
trot46351313tro_t_
troth85622203tro_th
troths95414153troths
trots56629943tro_ts
trotted83711283trotted
trotter73312253trotter
trotyl9236673trotyl
trout57332573trout_
trouts66116633trouts
trouty95211793trouty
trowth1277883trowth
wrote84717483wro_te
wroth116815883wro_th

Search took 7 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.376475242.0
2DLD Change Limit1127162915.56320261.7
3Display Results2912910.1102645.5
 (SQL Overall)1786912916.04929540.6
 
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.