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

189 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
cotters9432344(None) 
coaters93525791coaters
colters93522441colters
cooters94525721cooters
copters113621281copters
costers94128331costers
cottars94412241cottars
cotter84926671cotter_
cottiers10399151cottiers
couters93827301couters
cutters94218961cutters
dotters83715971dotters
jotters143413801jotters
lotters73921061lotters
otters64021511_otters
potters94024341potters
rotters74421391rotters
totters74618731totters
batters94626012batters
betters94422092betters
bitters94920362bitters
blotters104110982blotters
boaters93419242boaters
bolters94017802bolters
bothers124317752bothers
bottlers103810012bottlers
butters94521722butters
canters94827732canters
carters95327252carters
casters94729902casters
caters85336502c_aters
cattery123811602cattery
centers94420602centers
chatters134213952chatters
chitters133711172chitters
citers85022982c_iters
cithers124315772cithers
cittern9339142cittern
citterns10318122citterns
clatters103313912clatters
clouters10399802clouters
clutters103210352clutters
coalers94419352coalers
coasters104317332coasters
coatees93816552coatees
coater84329572coater_
coaxers164311082coaxers
cobbers134114752cobbers
cockers153618332cockers
codders114114452codders
coders95426982co_ders
codgers115113932codgers
coffers154112692coffers
coilers93619902coilers
coiners93620752coiners
cointers103616412cointers
colter84625092colter_
combers134516622combers
comers105328082co_mers
comtes106222812comte_s
confers124120092confers
congers104223232congers
conkers133721042conkers
conners94023112conners
contes84432912conte_s
cooers84324562co_oers
cookers134619462cookers
coolers93522492coolers
coopers114019482coopers
cooter85128612cooter_
copers104629842co_pers
copiers114215962copiers
coppers133519752coppers
copter109822012copter_
corders104520882corders
corers85231072co_rers
corkers134118852corkers
corners94723312corners
coshers123618182coshers
costars94218012costars
coster84331292coster_
cotes76347842co_te_s
cottagers12305382cottagers
cottar84613812cottar_
cottas84615572cott_as
cottered112511732cottered
cottier93814172cottier_
cottons9312192cottons
coulters103614312coulters
counters103320192counters
courters103015372courters
couter84930222couter_
covers114627962co_vers
coveters132411082coveters
cowers114625532co_wers
craters95021892craters
critters103511322critters
crofters13358902crofters
cutlers94217002cutlers
cutter84521002cutter_
doters74423912do_ters
dottels8327782dottels
dotter74419342dotter_
fetters103517902fetters
fitters104517752fitters
footers104618332footers
fosters104220102fosters
getters84216102getters
goiters84014442goiters
gutters83715512gutters
hatters104221522hatters
hitters104717592hitters
hooters104520482hooters
hotter94720082hotter_
jitters144314472jitters
jolters143711992jolters
jotter134315632jotter_
knotters12276152knotters
letters73819852letters
litters73422572litters
lofters103912902lofters
loiters74116612loiters
looters74419162looters
lotter64025602lotter_
lottery10389832lottery
lottes65322752lotte_s
matters94421752matters
molters93816972molters
mooters93818622mooters
mothers123717622mothers
mottes85523692motte_s
mottlers10388182mottlers
mutters94117142mutters
natters73718062natters
netters73618582netters
noters64021002no_ters
nutters74215432nutters
oaters65029792_oaters
others93918002_others
ottars64112222_ottars
otter54423972_otter_
outers64230172_outers
oxters134813272_oxters
patters94825192patters
petters93722362petters
plotters104011552plotters
porters93722702porters
posters93928012posters
pothers123818622pothers
potter83926982potter_
pottery123011072pottery
potzers184010542potzers
pouters94221872pouters
powters124015662powters
putters94219192putters
ratters74422472ratters
ritters74020622ritters
rooters74522932rooters
rosters73727542rosters
rotter64325462rotter_
rottes64524832rotte_s
routers74822872routers
scatters103612752scatters
scooters103511032scooters
scoters93313812sco_ters
scouters103411322scouters
scutters103311022scutters
setters73822062setters
sitters74221552sitters
slotters84012402slotters
sorters74221132sorters
souters74422602souters
spotters104313382spotters
swotters11448482swotters
tatters74520482tatters
tetters74320472tetters
titters74219622titters
tooters73818772tooters
toters65026362to_ters
totter65021462totter_
tottery10388482tottery
touters74018352touters
trotters83310242trotters
utters63817122_utters
vetters104016322vetters
voters95017442vo_ters
wetters103817752wetters
yatters103914622yatters
zosters163015412zosters

Search took 4 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 Filter1786911076710.373479064.3
2DLD Change Limit1076711893.08034958.1
3Display Results1891890.0603150.0
 (SQL Overall)1786911893.51350865.6
 
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.