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

132 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
garotters105503(None) 
garotter965941garotter_
garottes978281garotte_s
garotes8614562garo_te_s
garotte868702garotte__
garotted1066192garotte_d
garroters1055812garroters
garrottes1065482garrotte_s
garters84218232gar__ters
gavottes1274182gavotte_s
gritters94210632g_ritters
grouters95910082g_routers
rotters74421392__rotters
trotters83310242_trotters
abetters1057173_abetters
aborters1038573_aborters
abutters1056993_abutters
adopters1136693_adopters
allotters965563allotters
arbiters1038853_arbiters
arousers84810983_arousers
barometers14198513barometers
barraters1138043barraters
barters94223033bar__ters
batters94626013ba__tters
blotters104110983_blotters
brothers133410833_brothers
calottes10610083calotte_s
carolers103314173caro_lers
carollers1137703carollers
carousers1156743carousers
carters95327253car__ters
cavorters1434973cavorters
cotters94323443__cotters
critters103511323_critters
crofters13358903_crofters
darters84017603dar__ters
dotters83715973__dotters
fagoters1234863fago_ters
fretters113410303_fretters
fritters113810783_fritters
frothers14279813_frothers
frotteurs1242223_frotteurs
gagsters10317083ga_gsters
gaiters83516543ga__iters
galettes93111163galette_s
gamesters1236733gamesters
gangsters11205733gangsters
ganisters10248313ganisters
gaolers83511563ga_o_lers
garblers113810283gar_blers
gardeners1136603gardeners
garglers10418263gar_glers
garners83815983gar__ners
garote7717953garo_te__
garoted9710133garo_te_d
garotting1136103garotting
garroter956573garroter_
garrotes969363garrote_s
garrotte965683garrotte__
garrotted1164133garrotte_d
garter74420513gar__ter_
gasoliers1044203gasoliers
gasometers1346643gasometers
gasters85624293ga__sters
gaters74728643ga___ters
gathers114315073ga__thers
gavotte1174603gavotte__
gavotted1363343gavotte_d
gazetteers2041193gazetteers
gazettes18296863gazette_s
getters84216103g__etters
glitters93710543g_litters
gloaters9288863g_loaters
goiters84014443g__oiters
grafters12409193g_rafters
granters93614143g_ranters
graters85419743g_r_aters
greeters92610113g_reeters
grifters12389233g_rifters
gristers94013403g_risters
gritter83913353g_ritter_
groaners9248503g_roaners
grocers103511253g_ro_cers
groomers11388483g_roomers
groovers12337123g_roovers
gropers104813853g_ro_pers
grossers94410973g_rossers
grottier9316673g_rottier_
grottoes9276753g_rottoes
grottos8337333g_rott_os
groupers11358643g_roupers
grousers93810733g_rousers
grouter84412523g_router_
growers113612723g_ro_wers
growlers12327093g_rowlers
grunters9359033g_runters
gutters83715513g__utters
hatters104221523ha__tters
jotters143413803__jotters
knotters12276153_knotters
lotters73921063__lotters
marketers1545983marketers
matters94421753ma__tters
narraters946703narraters
natters73718063na__tters
otters64021513___otters
parroters1156763parroters
partiers103514243par_tiers
partners102711133par_tners
partyers13277763par_tyers
patters94825193pa__tters
plotters104011553_plotters
potters94024343__potters
ratters74422473__ratters
ritters74020623__ritters
rooters74522933__rooters
rosters73727543__rosters
rotter64325463__rotter_
rottes64524833__rotte_s
routers74822873__routers
slotters84012403_slotters
spotters104313383_spotters
strutters955693strutters
swotters11448483_swotters
tatters74520483ta__tters
throttlers1352483throttlers
totters74618733__totters
trotter73312253_trotter_
uprooters1164253uprooters
warstlers12284713warstlers
yatters103914623ya__tters

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411326.70322175.3
3Display Results1321320.0462869.6
 (SQL Overall)1786911327.17224915.1
 
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.