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

483 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
trotters8331024(None) 
rotters74421391_rotters
totters74618731t_otters
trotter73312251trotter_
blotters104110982blotters
brothers133410832brothers
cotters94323442_cotters
critters103511322critters
crofters13358902crofters
dotters83715972_dotters
fretters113410302fretters
fritters113810782fritters
frothers14279812frothers
frotteurs1242222frotteurs
garotters1055032garotters
gritters94210632gritters
grouters95910082grouters
jotters143413802_jotters
knotters12276152knotters
lotters73921062_lotters
otters64021512__otters
plotters104011552plotters
potters94024342_potters
ratters74422472_ratters
ritters74020622_ritters
rooters74522932_rooters
rosters73727542_rosters
rotter64325462_rotter_
rottes64524832_rotte_s
routers74822872_routers
slotters84012402slotters
spotters104313382spotters
strutters955692strutters
swotters11448482swotters
tatters74520482t_atters
tetters74320472t_etters
throttlers1352482throttlers
titters74219622t_itters
tooters73818772t_ooters
tootlers8289502tootlers
toters65026362t_o_ters
totter65021462t_otter_
tottery10388482t_ottery
touters74018352t_outers
treaters83615842treaters
troffers14125432troffers
trollers83211212trollers
troopers10289442troopers
trotted83711282trotte_d
troupers10359442troupers
trousers83910632trousers
trovers103713322tro_vers
trowsers11428002trowsers
trusters83112262trusters
trysters11298372trysters
twitters11296772twitters
abetters1057173abetters
aborters1038573aborters
abutters1056993abutters
adopters1136693adopters
allotters965563allotters
arbiters1038853arbiters
arousers84810983arousers
batters94626013_batters
betters94422093_betters
bitters94920363_bitters
blatters104414093blatters
bloaters103311023bloaters
blotter94612853blotter_
boaters93419243_boaters
bolters94017803_bolters
boosters104013443boosters
bothers124317753_bothers
bottlers103810013_bottlers
broiders114211193broiders
broilers103210093broilers
brokers133111913bro_kers
bronzers19296983bronzers
brooders112610243brooders
brothels13277073brothels
brother123311333brother_
browsers13449203browsers
bruiters10329143bruiters
butters94521723_butters
chatters134213953chatters
chitters133711173chitters
clatters103313913clatters
clouters10399803clouters
clutters103210353clutters
coaters93525793_coaters
colters93522443_colters
cooters94525723_cooters
copters113621283_copters
costers94128333_costers
cottars94412243_cottars
cotter84926673_cotter_
cottiers10399153_cottiers
couters93827303_couters
crafters13419953crafters
craters95021893cr_aters
critter94113033critter_
critturs10374593critturs
croakers14288523croakers
crofter12299573crofter_
crooners103911393crooners
croppers143311483croppers
crosiers103312063crosiers
crossers103912703crossers
croutes94815653croute_s
crowders14398813crowders
crowers124614903cro_wers
crowners133710753crowners
crozers184111083cro_zers
croziers19287003croziers
cutters94218963_cutters
diopters1137693diopters
doters74423913_do_ters
dottels8327783_dottels
dotter74419343_dotter_
drafters12338523drafters
drifters12417913drifters
droners84114383dro_ners
droppers13318603droppers
drovers115212643dro_vers
drowners12428273drowners
druthers1275793druthers
emitters10349643emitters
emoters94712873emo_ters
erecters102611613erecters
fetters103517903_fetters
fitters104517753_fitters
flatters113814203flatters
flitters114312173flitters
floaters112711513floaters
flouters11419273flouters
flutters114010823flutters
footers104618333_footers
footlers113910793footlers
fosters104220103_fosters
fraters103517213fr_aters
fretter103412753fretter_
fritter103912773fritter_
fronter103611583fronter_
frontes104214163fronte_s
frontiers1254993frontiers
frosteds12305653frosteds
frother133110153frother_
frotteur1142503frotteur
frowners14377933frowners
fruiters11328183fruiters
garotter965943garotter_
garottes978283garotte_s
getters84216103_getters
glitters93710543glitters
gloaters9288863gloaters
goiters84014443_goiters
grafters12409193grafters
granters93614143granters
graters85419743gr_aters
greeters92610113greeters
grifters12389233grifters
gristers94013403gristers
gritter83913353gritter_
groaners9248503groaners
grocers103511253gro_cers
groomers11388483groomers
groovers12337123groovers
gropers104813853gro_pers
grossers94410973grossers
grottier9316673grottier_
grottoes9276753grottoes
grottos8337333grott_os
groupers11358643groupers
grousers93810733grousers
grouter84412523grouter_
growers113612723gro_wers
growlers12327093growlers
grunters9359033grunters
gutters83715513_gutters
hatters104221523_hatters
hitters104717593_hitters
hooters104520473_hooters
hotter94720083_hotter_
ironers74813553iro_ners
jitters144314473_jitters
jolters143711993_jolters
jotter134315633_jotter_
knitters12336623knitters
knotter11317643knotter_
kraters114212343kr_aters
letters73819853_letters
litters73422573_litters
lofters103912903_lofters
loiters74116613_loiters
looters74419163_looters
lotter64025603_lotter_
lottery10389833_lottery
lottes65322753_lotte_s
matters94421753_matters
molters93816973_molters
mooters93818623_mooters
mothers123717623_mothers
mottes85523693_motte_s
mottlers10388183_mottlers
mutters94117143_mutters
natters73718063_natters
netters73618583_netters
northers1139333northers
noters64021003_no_ters
nutters74215433_nutters
oaters65029793__oaters
omitters10277653omitters
orbiters1036593orbiters
orometers11310423orometers
others93918003__others
ottars64112223__ottars
otter54423973__otter_
outers64230173__outers
oxters134813273__oxters
patters94825193_patters
petters93722363_petters
platters103415283platters
plotter94113663plotter_
poofters1336923poofters
porters93722703_porters
posters93928013_posters
pothers123818623_pothers
potter83926983_potter_
pottery123011073_pottery
potzers184010543_potzers
pouters94221873_pouters
powters124015663_powters
praters94921653pr_aters
prattlers11195323prattlers
presters103419003presters
printers103214903printers
probers113514583pro_bers
proctors12311513proctors
prodders1237463prodders
proettes10312763proette_s
proffers16126593proffers
profiters14228313profiters
proggers12258163proggers
promoters13310093promoters
prompters1537553prompters
proofers13118363proofers
propers113619033pro_pers
prosers94219643pro_sers
prospers123012263prospers
proteas92015123pro_teas
protecters14168253protecters
protesters12169383protesters
proteus92511593pro_teus
provers123817793pro_vers
prowlers13328933prowlers
putters94219193_putters
quitters17238523quitters
quoters16369263quo_ters
rafters103715633_rafters
ranters73323643_ranters
rasters74629023_rasters
raters63936583_r_aters
rattens74213403_rattens
ratter64326313_ratter_
rattlers83510293_rattlers
renters74224813_renters
resters74130403_resters
reutters8138573reutters
rioters73615513_rioters
ritter63822423_ritter_
roamers93713463_roamers
roarers73812743_roarers
roasters83615933_roasters
robbers112814163_robbers
rockers133916553_rockers
rogers74517913_ro_gers
roisters83615553_roisters
rolfers104011813_rolfers
rollers73117473_rollers
rompers113412243_rompers
roofers105013903_roofers
roomers95416413_roomers
roosers74217873_roosers
roosters83514663roosters
rooter64926033_rooter_
ropers84325903_ro_pers
roster64329083_roster_
rotates72819773_rotate_s
rotators8310203_rotators
rotes56143903_ro_te_s
rotifers1136043_rotifers
rotors64917953_ro_tors
rotte54625933_rotte__
rotted74524433_rotte_d
rotten64115433_rotte_n
rousers75220143_rousers
rousters84315683_rousters
router65025843_router_
routes66129313_route_s
rovers95423523_ro_vers
rowers94924573_ro_wers
roysters113610533_roysters
rozzers1535633_rozzers
scatters103612753scatters
scooters103511033scooters
scoters93313813sco_ters
scouters103411323scouters
scutters103311023scutters
setters73822063_setters
shatters113313913shatters
shooters112811583shooters
shouters113510623shouters
shutters113611353shutters
sitters74221553_sitters
skitters12349553skitters
slitters84014133slitters
slotter73314453slotter_
smatters104011713smatters
smothers13349933smothers
snorters83410583snorters
soothers113913433soothers
sorters74221133_sorters
souters74422603_souters
spatters103914703spatters
spitters104113383spitters
sporters103714063sporters
spotter94514883spotter_
spouters104011163spouters
sputters104012873sputters
strokers123910903stro_kers
strollers937543strollers
stroppers1356713stroppers
stroyers11388923stro_yers
strutter846503strutter_
stutters83210473stutters
swatters113911793swatters
swotter10399473swotter_
tapsters10318803tapsters
tasters74225643t_asters
taters64932203t__aters
tatter64024573t_atter_
tattlers8369693tattlers
taunters8259273taunters
teeters74018303t_eeters
teethers11328713teethers
tempters12257293tempters
tenters73921103t_enters
testers74124543t_esters
tethers103815313t_ethers
tetter64322453t_etter_
theaters114211903theaters
throbbers1643173throbbers
throttler1262863throttler_
throttles1254353throttles
throwers14106033thro_wers
throwsters1642713throwsters
thrusters1245333thrusters
tilters73315953t_ilters
tinters74221113t_inters
tipsters10278513tipsters
titers64526413t__iters
titfers10318933t_itfers
tithers104216733t_ithers
titter63421163t_itter_
toasters83912723toasters
tochers123413093t_ochers
toilers74116263t_oilers
tokers104818893t_o_kers
tollers73217463t_ollers
toners64128003t_o_ners
tongers84116013t_ongers
tonners73816403t_onners
toolers74416503t_oolers
tooter64420803t_ooter_
tootler73511123tootler_
tootles72915603tootle_s
tootses72910773tootse_s
topers85025323t_o_pers
toppers113914603t_oppers
torquers17204303torquers
tortes64826053t_orte_s
torturers944343torturers
tortures838913tortures
tossers74713503t_ossers
totems86810763t_o_tems
toter55932133t_o_ter_
totes55139683t_o_te_s
tother94117143t_other_
totted74319953t_otte_d
tottered9208703t_ottered
totterer8217793t_otterer
totterers9186813t_otterers
tourers73512743t_ourers
touter63821033t_outer_
towers94423673t_o_wers
toyers95516333t_o_yers
tracers94917843tr_acers
trackers143512853trackers
tractors10312563tractors
traders84316953tr_aders
trailers82912923trailers
trainers83114643trainers
traitors8310793traitors
trampers123210393trampers
trappers123711043trappers
trashers113013643trashers
trawlers113310203trawlers
treaders93311843treaders
treater74219833treater_
trekkers1133803trekkers
trickers143812813trickers
triers64321523tr__iers
triflers113110213triflers
triggers10257843triggers
trillers83613493trillers
trimers94615143tr_imers
trimeters1139213trimeters
trimmers12288913trimmers
trippers123210163trippers
triter65120593tr_iter_
trocars959043tro_cars
trochars1377853trochars
trochees132510183trochees
troches123715343troche_s
troffer13125863troffer_
trokes104019263tro_ke_s
troller73913173troller_
trolleys11315693trolleys
trommels12254333trommels
trompes114111623trompe_s
trones65629283tro_ne_s
trooper94210363trooper_
tropes84824353tro_pe_s
trothed114010973trothe_d
troths95414153tro_t_hs
trots56629943tro_t__s
trotting92510913trotting
trotyls10236033tro_tyls
troublers1135003troublers
trouncers1134803trouncers
trouper93811433trouper_
troupes94112853troupe_s
trouser73812473trouser_
troutier8277153troutier_
trouts66116633trout__s
trouvere1144073trouvere
trouveres1243773trouveres
trouveurs1241643trouveurs
trover95014663tro_ver_
troves94719113tro_ve_s
trowelers12105263trowelers
trowels10358363tro_wels
trowths1365023trowt_hs
truckers14279013truckers
trudgers10256863trudgers
trussers8348283trussers
trustees8339323trustees
truster73114313truster_
trustors8268913trustors
tryster10369513tryster_
trystes10419993tryste_s
tufters10298353t_ufters
turtlers8258203turtlers
tutoyers1133303tutoyers
tweeters11287143tweeters
twisters11268173twisters
twitter10278093twitter_
twittery14303893twittery
twofers1364053two_fers
uprooters1164253uprooters
ureters7311823ur_eters
utters63817123__utters
vetters104016323_vetters
voters95017443_vo_ters
wetters103817753_wetters
whetters14246653whetters
whitters14359403whitters
wresters112711733wresters
writers105513493wr_iters
writhers14398983writhers
wrongers12327773wrongers
yatters103914623_yatters
zosters163015413_zosters

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.420425454.8
2DLD Change Limit1461624836.73621698.6
3Display Results4834830.2032379.3
 (SQL Overall)1786914837.35924282.0
 
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.