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

167 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
garottes97828(None) 
garotes8614561garo_tes
garotte868701garotte_
garotted1066191garotted
garotter965941garotter
garotters1055031garotters
garrottes1065481garrottes
gavottes1274181gavottes
calottes10610082calottes
galettes93111162galettes
garote7717952garo_te_
garoted9710132garo_ted
garrotes969362garrotes
garrotte965682garrotte_
garrotted1164132garrotted
gavotte1174602gavotte_
gavotted1363342gavotted
gazettes18296862gazettes
grottoes9276752g_rottoes
grottos8337332g_rottos
rottes64524832__rottes
agaroses938823agaro_ses
arbutes939703_arbutes
aretes64425353_ar_etes
ariettes8411353_ariettes
arnottos8163853_arnottos
arouses74921293_arouses
azotes154312223_azo_tes
barbettes1348163barbettes
barites94322333bar_ites
baronets101410903baronets
baronies10315023baronies
baronnes1038553baronnes
baroques1934863baroques
barrettes1149063barrettes
barytes124611153bar_ytes
burettes1048953burettes
calotte9510563calotte_
capotes11314643capo_tes
carates95630613car_ates
carnotites1246543carnotites
caroches15710693caroches
carotenes11410203carotenes
carotids11229943carotids
carotins102315583carotins
carouses10614503carouses
cartes86239473car__tes
casettes1039653casettes
charlottes1543823charlottes
cigarettes1343333cigarettes
cocottes1238303cocottes
corotates112714283corotates
croutes94815653_croutes
culottes1076293culottes
curettes1039313curettes
dartles84014133dar_tles
frontes104214163_frontes
gahnites1235703gahnites
gaieties9310183gaieties
galette84212703galette_
gallates92815533gallates
galoots82410793galoot_s
galores82614343galo_res
galoshes1236913galoshes
gametes10312253ga_metes
garages9314113gar_ages
garbages1238183garbages
garbles104016923gar_bles
gargets94614573garget_s
gargles94214893gar_gles
gargoyles1442833gargoyles
garigues1034953garigues
garnets84115403garnet_s
garoting10510703garoting
garotting1136103garotting
garpikes1534373garpikes
garreted1057523garreted
garrets84413623garret_s
garrote8510103garrote_
garroted1056783garroted
garroter956573garroter
garroters1055813garroters
garter74420513gar__ter
garters84218233gar_ters
garths104111503gar__ths
gates65939513ga___tes
gavots1038113gavo_t_s
gayeties1236883gayeties
gazette17357363gazette_
gazetted19234853gazetted
gemotes103712143gemo_tes
genettes938303genettes
girolles935523girolles
glottis837173g_lottis
gotten73410113g__otten
gradates10510783gradates
granites92116363granites
grantees92510973grantees
grates75429893g_r_ates
gritted94110903g_ritted
gritter83913353g_ritter
gritters94210633g_ritters
groats74816653g_roat_s
grooves11368803g_rooves
gropes95220403g_ro_pes
grosses84517683g_rosses
grots65025853g_ro_t_s
grottier9316673g_rottier
grottiest10147183g_rottiest
grotto7349813g_rott_o
grottoed10234503g_rottoed
grotty10389833g_rott_y
grouses84616543g_rouses
grouted94111503g_routed
grouter84412523g_router
grouters95910083g_routers
grouts75015613g_rout_s
groves104318103g_ro_ves
growths1494423g_rowths
groynes1137823g_roynes
grutten885283g_rutten
gyrates113610263gyr_ates
jarosites1647373jarosites
karates115617473kar_ates
karosses1236493karosses
lattes65324203la__ttes
layettes1136263layettes
lottes65322753__lottes
marlites103415263marlites
marmites122212793marmites
mattes85624533ma__ttes
mottes85523693__mottes
narrates8312763narrates
navettes1136613navettes
palettes103112833palettes
parietes10714543parietes
parities10522973parities
parkettes15137593parkettes
parodies11313693parodies
parolees104313983parolees
paroles95025883paro_les
parotids112610413parotids
parotitis1149173parotitis
parties93230863par_ties
proettes10312763_proettes
rarities8316333rarities
reroutes8312223reroutes
rotates72819773__rotates
rotes56143903__ro_tes
rotte54625933__rotte_
rotted74524433__rotted
rotten64115433__rotten
rotter64325463__rotter
rotters74421393__rotters
routes66129313__routes
sapotes9313943sapo_tes
sarodes84216143saro_des
saroses73619333saro_ses
syrettes1136963syrettes
tarots66422993taro_t_s
throttles1254353throttles
trotted83711283_trotted
trotter73312253_trotter
trotters83310243_trotters
variates111214983variates
warstles11368803warstles
zaratites1847003zaratites

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 Limit1461621677.78318779.6
3Display Results1671670.0632650.8
 (SQL Overall)1786911678.28221575.8
 
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.