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

170 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
garotter96594(None) 
garotte868701garotte_
garotted1066191garotted
garotters1055031garotters
garottes978281garottes
garote7717952garo_te_
garoted9710132garo_ted
garotes8614562garo_tes
garroter956572garroter
garrotte965682garrotte_
garrotted1164132garrotted
garrottes1065482garrottes
garter74420512gar__ter
gavotte1174602gavotte_
gavotted1363342gavotted
gavottes1274182gavottes
gritter83913352g_ritter
grottier9316672g_rottier
grouter84412522g_router
rotter64325462__rotter
trotter73312252_trotter
abetter958323_abetter
aborter939933_aborter
abutter957513_abutter
adopter1036763_adopter
adroiter946193adroiter
aglitter935093aglitter
allotter866473allotter
another10289153_another
arbiter939933_arbiter
arouser74514423_arouser
artier63419733_ar_tier
barometer13189043barometer
barrater10310143barrater
barter85525373bar__ter
batter84928873ba__tter
blotter94612853_blotter
brother123311333_brother
calotte9510563calotte_
calottes10610083calottes
caroler93816753caro_ler
caroller1039203caroller
carouser1068853carouser
carrotier1146623carrotier
carter84932273car__ter
cavorter1335783cavorter
cotter84926673__cotter
critter94113033_critter
crofter12299573_crofter
darter75320363dar__ter
dotter74419343__dotter
fagoter1135883fago_ter
farther1348343far_ther
fatter94523213fa__tter
fretter103412753_fretter
fritter103912773_fritter
fronter103611583_fronter
frother133110153_frother
frotteur1142503_frotteur
gagster9317633ga_gster
gaiter73819503ga__iter
galette84212703galette_
galettes93111163galettes
gamester1137323gamester
gangster10215773gangster
ganister9178993ganister
gaoler73913573ga_o_ler
garbler104012563gar_bler
gardener1037103gardener
gargler93710263gar_gler
garner73917003gar__ner
garoting10510703garoting
garotting1136103garotting
garreted1057523garreted
garrote8510103garrote_
garroted1056783garroted
garroters1055813garroters
garrotes969363garrotes
garters84218233gar__ters
gasolier935833gasolier
gasometer1267083gasometer
gaster75027353ga__ster
gater64533653ga___ter
gather104115863ga__ther
gaunter82910713ga_unter
gazette17357363gazette_
gazetted19234853gazetted
gazetteer1941393gazetteer
gazettes18296863gazettes
getter74117613g__etter
glitter84211803g_litter
gloater83711013g_loater
goiter74116203g__oiter
gotten73410113g__otten
grafter114211153g_rafter
granter84117133g_ranter
grater74625443g_r_ater
greater84416493g_reater
greeter82812673g_reeter
grifter113810493g_rifter
grister83915413g_rister
gritted94110903g_ritted
gritters94210633g_ritters
grittier9316263g_rittier
groaner82510133g_roaner
grocer94212143g_ro_cer
grodier939673g_rodier
groomer10399873g_roomer
groover11358543g_roover
groper94517253g_ro_per
grosser84313143g_rosser
grotto7349813g_rott_o
grottoed10234503g_rottoed
grottoes9276753g_rottoes
grottos8337333g_rottos
grotty10389833g_rott_y
grouper104210093g_rouper
grouser84513693g_rouser
grouted94111503g_routed
grouters95910083g_routers
groutier9297173g_routier
grower104614933g_ro_wer
growler11318973g_rowler
grunter83110783g_runter
grutten885283g_rutten
gutter73817713g__utter
hatter94724873ha__tter
hotter94720083__hotter
jotter134315633__jotter
knotter11317643_knotter
latter65027893la__tter
lotter64025603__lotter
marketer1437383marketer
matter84325343ma__tter
narrater838723narrater
natter64420743na__tter
otter54423973___otter
parroter1058203parroter
partier93520713par_tier
partner92811393par_tner
partyer12337873par_tyer
patter84628263pa__tter
plotter94113663_plotter
potter83926983__potter
ratter64326313__ratter
ritter63822423__ritter
rooter64926033__rooter
roster64329083__roster
rotte54625933__rotte_
rotted74524433__rotted
rotten64115433__rotten
rotters74421393__rotters
rottes64524833__rottes
router65025843__router
slotter73314453_slotter
spotter94514883_spotter
strutter846503strutter
swotter10399473_swotter
tarter64023563tar__ter
tartier74123263tar_tier
tatter64024573ta__tter
throttler1262863throttler
totter65021463__totter
trotted83711283_trotted
trotters83310243_trotters
uprooter1085243uprooter
warstler11275933warstler
wartier103413913war_tier
watter93221983wa__tter
yatter94116213ya__tter

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621706.65621959.4
3Display Results1701700.0602833.3
 (SQL Overall)1786911707.13925030.3
 
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.