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 “toters” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

252 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
toters6502636(None) 
doters74423911doters
noters64021001noters
otters64021511otters
taters64932201taters
titers64526411titers
tokers104818891tokers
toners64128001toners
tooters73818771tooters
topers85025321topers
totems86810761totems
toter55932131toter_
totes55139681tote_s
totters74618731totters
touters74018351touters
towers94423671towers
toyers95516331toyers
voters95017441voters
afters94717072afters
alters64924222alters
asters65631602asters
atoners75013952atoners
biters83925242biters
boaters93419242boaters
bolters94017802bolters
boners84825432boners
borers85122682borers
botels84815802botels
bothers124317752bothers
bowers115523702bowers
boxers155013482boxers
caters85336502caters
citers85022982citers
coaters93525792coaters
coders95426982coders
colters93522442colters
comers105328082comers
cooers84324562cooers
cooters94525722cooters
copers104629842copers
copters113621282copters
corers85231072corers
costers94128332costers
cotes76347842cote_s
cotters94323442cotters
couters93827302couters
covers114627962covers
cowers114625532cowers
daters74827372daters
deters74724682deters
doers65225712do_ers
dopers95522482dopers
dosers75723632dosers
doter65428622doter_
dotes65836692dote_s
dotters83715972dotters
dowers104523292dowers
dozers164815422dozers
eaters65535952eaters
emoters94712872emoters
enters64425642enters
esters64627732esters
footers104618332footers
fosters104220102fosters
foyers125413132foyers
gaters74728642gaters
goers65520252go_ers
gofers104711512gofers
goiters84014442goiters
gomers94116882gomers
goners74420172goners
haters94930402haters
hoers85724922ho_ers
homers114821972homers
honers94324972honers
hooters104520472hooters
hopers114222972hopers
hosers95223962hosers
hotels94515512hotels
hovers124320252hovers
inters64328052inters
jokers175511192jokers
jolters143711992jolters
jotters143413802jotters
kiters105218592kiters
liters65429882liters
lofters103912902lofters
loiters74116612loiters
loners64225812loners
looters74419162looters
lopers84424142lopers
losers65123582losers
lotters73921062lotters
lovers94223432lovers
lowers94624922lowers
maters85032392maters
meters85625832meters
miters84328782miters
molters93816972molters
mooters93818622mooters
mopers104220372mopers
motels83616892motels
motes75944002mote_s
motets84216192motets
mothers123717622mothers
motors84616602motors
movers115117192movers
mowers113219402mowers
niters64624212niters
noter55025642noter_
notes55034582note_s
oaters65029792oaters
omers76923192_omers
others93918002others
ottars64112222ottars
otter54423972otter_
outers64230172outers
overs85224792_overs
oxters134813272oxters
oyers87620882_oyers
paters84935832paters
peters86624592peters
pokers124617922pokers
polers84225642polers
porters93722702porters
posers84223972posers
posters93928012posters
pothers123818622pothers
potters94024342potters
potzers184010542potzers
pouters94221872pouters
powers113822322powers
powters124015662powters
quoters16369262quoters
raters63936582raters
rioters73615512rioters
rogers74517912rogers
rooters74522932rooters
ropers84325902ropers
rosters73727542rosters
rotes56143902rote_s
rotors64917952rotors
rotters74421392rotters
routers74822872routers
rovers95423522rovers
rowers94924572rowers
scoters93313812scoters
sobers85218862sobers
sorters74221132sorters
souters74422602souters
sowers94923442sowers
staters73922342staters
stokers114515182stokers
stoners74817952stoners
stopers94217372stopers
storers75018682storers
stovers103713732stovers
tabers84621572tabers
takers103923742takers
talers64628142talers
tamers84224032tamers
tapers84025812tapers
tasters74225642tasters
tatars64619792tatars
tater54138612tater_
tates55444982tate_s
tatters74520482tatters
tawers94118602tawers
taxers134015282taxers
teeters74018302teeters
tenters73921102tenters
testers74124542testers
tethers103815312tethers
tetters74320472tetters
tiers55526522t_iers
tigers75616512tigers
tilers63523502tilers
tilters73315952tilters
timers84420992timers
tinters74221112tinters
titer55430612titer_
titfers10318932titfers
tithers104216732tithers
titres64718932titres
titters74219622titters
toasters83912722toasters
tochers123413092tochers
toeas55726422to_eas
toes46956442to_e_s
toilers74116262toilers
tokens104711562tokens
toker95924912toker_
tokes95234972toke_s
tolars64817942tolars
toles55147132tole_s
tollers73217462tollers
tomes76037382tome_s
toner55336242toner_
tones56048662tone_s
tongers84116012tongers
tonners73816402tonners
toolers74416502toolers
tooter64420802tooter_
tootlers8289502tootlers
topees85519702topees
toper75231022toper_
topes76941762tope_s
toppers113914602toppers
torero6313202torero
toreros7311342toreros
tores55352672tore_s
torrs53923562to_rrs
tors46157382to__rs
tortes64826052torte_s
tossers74713502tossers
totals63115162totals
tote46643672tote__
toted64929482tote_d
totem74819372tote_m
tother94117142tother_
tots46654122tot__s
totter65021462totter_
tottery10388482tottery
tourers73512742tourers
tours55325892to_urs
touter63821032touter_
towels94314642towels
tower85729202tower_
towery124012092towery
toyer84521552toyer_
triers64321522triers
trotters83310242trotters
trovers103713322trovers
tubers85017032tubers
tufters10298352tufters
tuners64417342tuners
tutees6514552tutees
tutors6912332tutors
tuyers94612562tuyers
twiers95410162twiers
twofers1364052twofers
twyers12497412twyers
tyers86220052t_yers
utters63817122utters
vomers115614942vomers
voter85121052voter_
votes84627082vote_s
vowers124317182vowers
waters95030632waters
wooers93712442wooers
zoners155115992zoners
zosters163015412zosters

Search took 3 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 Filter178691825510.326548131.9
2DLD Change Limit825512522.34635188.0
3Display Results2522520.0932709.7
 (SQL Overall)1786912522.76564626.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.