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
noters64020991noters
otters64021511otters
taters64932191taters
titers64526401titers
tokers104818891tokers
toners64128001toners
tooters73818771tooters
topers85025321topers
totems86810761totems
toter55932131toter_
totes55139681tote_s
totters74618731totters
touters74018331touters
towers94423671towers
toyers95516331toyers
voters95017441voters
afters94717072afters
alters64924222alters
asters65631602asters
atoners75013952atoners
biters83925232biters
boaters93419232boaters
bolters94017802bolters
boners84825432boners
borers85122682borers
botels84815802botels
bothers124317752bothers
bowers115523702bowers
boxers155013482boxers
caters85336492caters
citers85022972citers
coaters93525772coaters
coders95426972coders
colters93522432colters
comers105328082comers
cooers84324562cooers
cooters94525712cooters
copers104629842copers
copters113621272copters
corers85231072corers
costers94128302costers
cotes76347842cote_s
cotters94323432cotters
couters93827282couters
covers114627962covers
cowers114625532cowers
daters74827362daters
deters74724682deters
doers65225712do_ers
dopers95522482dopers
dosers75723632dosers
doter65428622doter_
dotes65836692dote_s
dotters83715972dotters
dowers104523292dowers
dozers164815422dozers
eaters65535942eaters
emoters94712872emoters
enters64425642enters
esters64627732esters
footers104618332footers
fosters104220092fosters
foyers125413132foyers
gaters74728632gaters
goers65520252go_ers
gofers104711512gofers
goiters84014432goiters
gomers94116882gomers
goners74420162goners
haters94930392haters
hoers85724922ho_ers
homers114821972homers
honers94324972honers
hooters104520462hooters
hopers114222972hopers
hosers95223952hosers
hotels94515502hotels
hovers124320252hovers
inters64328042inters
jokers175511192jokers
jolters143711992jolters
jotters143413802jotters
kiters105218582kiters
liters65429872liters
lofters103912902lofters
loiters74116612loiters
loners64225802loners
looters74419162looters
lopers84424142lopers
losers65123582losers
lotters73921062lotters
lovers94223432lovers
lowers94624922lowers
maters85032382maters
meters85625832meters
miters84328772miters
molters93816972molters
mooters93818622mooters
mopers104220372mopers
motels83616892motels
motes75944002mote_s
motets84216192motets
mothers123717622mothers
motors84616592motors
movers115117192movers
mowers113219402mowers
niters64624202niters
noter55025642noter_
notes55034582note_s
oaters65029782oaters
omers76923192_omers
others93918002others
ottars64112222ottars
otter54423972otter_
outers64230162outers
overs85224792_overs
oxters134813272oxters
oyers87620882_oyers
paters84935822paters
peters86624592peters
pokers124617922pokers
polers84225642polers
porters93722702porters
posers84223972posers
posters93927992posters
pothers123818622pothers
potters94024342potters
potzers184010542potzers
pouters94221862pouters
powers113822322powers
powters124015652powters
quoters16369252quoters
raters63936572raters
rioters73615502rioters
rogers74517912rogers
rooters74522932rooters
ropers84325902ropers
rosters73727532rosters
rotes56143902rote_s
rotors64917932rotors
rotters74421392rotters
routers74822852routers
rovers95423522rovers
rowers94924572rowers
scoters93313792scoters
sobers85218852sobers
sorters74221112sorters
souters74422582souters
sowers94923432sowers
staters73922322staters
stokers114515182stokers
stoners74817952stoners
stopers94217362stopers
storers75018682storers
stovers103713732stovers
tabers84621572tabers
takers103923742takers
talers64628142talers
tamers84224032tamers
tapers84025812tapers
tasters74225642tasters
tatars64619792tatars
tater54138612tater_
tates55444982tate_s
tatters74520482tatters
tawers94118602tawers
taxers134015282taxers
teeters74018302teeters
tenters73921102tenters
testers74124542testers
tethers103815312tethers
tetters74320472tetters
tiers55526522t_iers
tigers75616502tigers
tilers63523492tilers
tilters73315932tilters
timers84420992timers
tinters74221102tinters
titer55430612titer_
titfers10318932titfers
tithers104216732tithers
titres64718932titres
titters74219612titters
toasters83912702toasters
tochers123413092tochers
toeas55726422to_eas
toes46956442to_e_s
toilers74116262toilers
tokens104711562tokens
toker95924912toker_
tokes95234972toke_s
tolars64817922tolars
toles55147132tole_s
tollers73217452tollers
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
tossers74713492tossers
totals63115162totals
tote46643672tote__
toted64929482tote_d
totem74819362tote_m
tother94117142tother_
tots46654122tot__s
totter65021462totter_
tottery10388482tottery
tourers73512732tourers
tours55325862to_urs
touter63821032touter_
towels94314642towels
tower85729202tower_
towery124012092towery
toyer84521552toyer_
triers64321522triers
trotters83310232trotters
trovers103713312trovers
tubers85017022tubers
tufters10298342tufters
tuners64417342tuners
tutees6514552tutees
tutors6912322tutors
tuyers94612562tuyers
twiers95410162twiers
twofers1364052twofers
twyers12497412twyers
tyers86220052t_yers
utters63817112utters
vomers115614942vomers
voter85121052voter_
votes84627082vote_s
vowers124317182vowers
waters95030622waters
wooers93712442wooers
zoners155115992zoners
zosters163015402zosters

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.1561145455.1
2DLD Change Limit825512522.68630733.8
3Display Results2522520.0803150.0
 (SQL Overall)1786912522.92261153.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.