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

196 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
garotted106619(None) 
garoted9710131garo_ted
garotte868701garotte_
garotter965941garotter
garottes978281garottes
garrotted1164131garrotted
gavotted1363341gavotted
garote7717952garo_te_
garotes8614562garo_tes
garotters1055032garotters
garreted1057522garreted
garroted1056782garroted
garrotte965682garrotte_
garrottes1065482garrottes
gavotte1174602gavotte_
gavottes1274182gavottes
gazetted19234852gazetted
gritted94110902g_ritted
grottoed10234502g_rottoed
grouted94111502g_routed
rotted74524432__rotted
trotted83711282_trotted
abetted1058323_abetted
aborted10310423_aborted
abutted1056983_abutted
adopted1136253_adopted
allotted986873allotted
arointed939003_arointed
aroused84914343_aroused
aroynted1244523_aroynted
azoted16388593_azo_ted
batted95623653ba__tted
bedotted1234983bedotted
besotted1135843besotted
blotted103911833_blotted
calotte9510563calotte_
calottes10610083calottes
caroled103717693caro_led
carolled1138833carolled
caromed123713623caro_med
carotid102014833caro_tid
caroused1149253caroused
carpeted1338953carpeted
carted98631443car__ted
cartoned111312833cartoned
catted95422473ca__tted
cavorted1435693cavorted
clotted104011823_clotted
corotated122810053corotated
curetted1137173curetted
darted84620923dar__ted
dartled9409853dar_tled
deratted1048403deratted
dogtrotted1351783dogtrotted
dotted84717523__dotted
dratted9358593_dratted
earthed1139923ear_thed
enrooted977423enrooted
facetted1445743facetted
fagoted1236073fago_ted
farted105121783far__ted
fatted105419843fa__tted
fretted113411853_fretted
fritted113611333_fritted
fronted114011273_fronted
frosted113211873_frosted
frothed14288783_frothed
gadrooned1243403gadrooned
gaited84416923ga__ited
galeated104111583galeated
galette84212703galette_
galettes93111163galettes
galleted1038223galleted
galoped11138083galo_ped
galoshed1334493galoshed
gaoled84814503ga_o_led
garaged1039253gar_aged
garbed104815663gar__bed
garbled114512803gar_bled
gardened1137003gardened
gargled104210673gar_gled
gargoyled1541993gargoyled
garmented1345883garmented
garnered10247113garnered
garoting10510703garoting
garotting1136103garotting
garred85217413gar__red
garrote8510103garrote_
garroter956573garroter
garrotes969363garrotes
garter74420513gar__ter
gartered10319593gartered
gasted84821583ga__sted
gated75329773ga___ted
gazette17357363gazette_
gazettes18296863gazettes
ghosted1236273g_hosted
girted83912873gir__ted
girthed12266243gir_thed
gitted84015053g__itted
gloated93511533g_loated
glouted9429713g_louted
glutted937243g_lutted
gorgeted1135353gorgeted
gotten73410113g__otten
gradated1157433gradated
grafted124110223g_rafted
granted94715103g_ranted
grated84523923g_r_ated
greeted93111383g_reeted
grifted12379583g_rifted
gritter83913353g_ritter
groaned9259973g_roaned
groined92710813g_roined
grokked1233673g_rokked
groomed11379503g_roomed
grooved12347253g_rooved
groped107515053g_ro_ped
grossed93812253g_rossed
grottier9316673g_rottier
grotto7349813g_rott_o
grottoes9276753g_rottoes
grottos8337333g_rottos
grotty10389833g_rott_y
grouped11419193g_rouped
groused94712833g_roused
grouter84412523g_router
groved114413703g_ro_ved
growled12278173g_rowled
grunted9339283g_runted
grutten885283g_rutten
gutted84716363g__utted
gyrated12428413gyr_ated
hatted104921513ha__tted
hotted104319943__hotted
jotted143615173__jotted
knotted12357233_knotted
lariated91212063lariated
lotted74222403__lotted
marketed1537323marketed
marooned1138563marooned
marted94425213mar__ted
matted94521413ma__tted
narrated9310323narrated
parented11912213parented
pargeted1238683pargeted
pargetted1345663pargetted
parodied1238333parodied
paroled104217633paro_led
parotid102915513paro_tid
parotoid11410033parotoid
parroted1158843parroted
parted94228683par__ted
partied103516553par_tied
patted94724683pa__tted
plotted104612373_plotted
potted94624013__potted
ragouted1034423ragouted
ratted74923343__ratted
repotted1139283repotted
rerouted9311143rerouted
retted74826313__retted
rooted75424003__rooted
rotated82715293__rotated
rotte54625933__rotte_
rotten64115433__rotten
rotter64325463__rotter
rottes64524833__rottes
routed75624333__routed
rutted74518403__rutted
shotted113912403_shotted
slotted84613883_slotted
sotted74121403__sotted
spotted103713143_spotted
sprouted1136393sprouted
stotted83511423_stotted
strutted946343strutted
swotted11398713_swotted
targeted1037483targeted
tarted74923373tar__ted
tatted74920533ta__tted
throated1247923throated
throttled1352963throttled
totted74319953__totted
trothed114010973_trothed
trotter73312253_trotter
undotted1048523undotted
unpotted11108393unpotted
unrooted9810513unrooted
uprooted1186393uprooted
variated121211393variated
varoomed1445293varoomed
vatted104214733va__tted
warstled12286123warstled
warted104223233war__ted
wotted104115713__wotted

Search took 9 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 Filter1786911461620.436409841.7
2DLD Change Limit1461621968.17317883.5
3Display Results1961960.0762578.9
 (SQL Overall)1786911968.68520574.7
 
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.