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

272 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
adopter103676(None) 
adapter1036171adapter
adepter1036111adepter
adopted1136251adopted
adoptee1048411adoptee
adopters1136691adopters
aborter939932aborter
adapted1135842adapted
adapters1136102adapters
adaptor1034952adaptor
adopt81219742adopt__
adoptees1145122adoptees
adopts998082adopt_s
adorer74713452ado_rer
adorner8246982adorner
adroiter946192adroiter
apter76120202a__pter
copter109822012_copter
diopter1038472diopter
doper86128392_dop_er
dopier93515922_dopier
doter65428622_do_ter
dotter74419342_dotter
abater85518123a_bater
abetter958323abetter
aborted10310423aborted
aborters1038573aborters
abrupter1243793abrupter
abutter957513abutter
accepter14144933accepter
accouter1245363accouter
acuter84412863a_cuter
adapt81218553adapt__
adaptors1145263adaptors
adapts9107813adapt_s
adder75419593ad__der
adducer1184163adducer
adept81219643adept__
adeptest1145453adeptest
adeptly1344183adeptly
adepts9117103adept_s
adherer1137573adherer
adjurer1534823adjurer
adjuster1644353adjuster
admirer1035523admirer
admitter1135113admitter
adnate72913483adnate_
adobe84814713ado_be_
adobes94411533ado_bes
adopting1237453adopting
adoption1146083adoption
adoptive1445503adoptive
adore65723673ado_re_
adored84714243ado_red
adorers84411733ado_rers
adores74420723ado_res
adorned9256893adorned
adorners9196623adorners
adoze155713833ado_ze_
adsorber1143503adsorber
adultery1244223adultery
adviser11135783adviser
after85719793a__fter
alerter72111513alerter
allotter866473allotter
alter54828503a__lter
ammeter1148393ammeter
ampler104313303a_mpler
anointer837823anointer
another10289153another
aper66336233a__p_er
apposer1147483apposer
arbiter939933arbiter
arouser74514423arouser
asper75520433a_sp_er
assorter866673assorter
aster55434893a__ster
atoner64817193ato_ner
atopies92816433atopies
averter102410553averter
avoider1155813avoider
avower1236823avo_wer
awaiter1057443awaiter
azote144416343azo_te_
azoted16388593azo_ted
azotes154312223azo_tes
bloater94013423bloater
blotter94612853blotter
boater84622093_boater
bolter83920753_bolter
booster94314553booster
bopper123813833_bopper
cadaster1136903cadaster
calypter1544063calypter
cavorter1335783cavorter
chapter144213853chapter
chopper163611893chopper
clouter93511693clouter
coater84329573_coater
colter84625093_colter
cooper104221123coop_er
coopted123710763coopted
cooter85128613_cooter
coper95336093_cop_er
copier103722893_copier
copper124321893_copper
copters113621283_copters
coster84331293_coster
cotter84926673_cotter
couter84930223_couter
crofter12299573crofter
cropper133312963cropper
dabster1036703dabster
dafter104813343_dafter
damper114117753damp_er
dapper114016633_dapper
darter75320363_darter
dater65332313_d_ater
daunter83811753daunter
defter104215923_defter
deter65028043_d_eter
dexter143810893_dexter
dieter73516773_dieter
diopters1137693diopters
dioptre1055763dioptre
dipper114017793_dipper
diptera1037213_diptera
doated84118183_doated
dobber114015423_dobber
docker134417653_docker
doctor938993_doctor
dodder94712913_dodder
dodger95817053_dodger
doer57734703_do__er
doffer133911353_doffer
dogger95216783_dogger
doited85016633_doited
doozer163910463_doozer
dope76038893_dop_e_
doped95326713_dop_ed
dopers95522483_dop_ers
dopes84935043_dop_es
dopester1137253_dopester
dopey116020353_dop_ey
dormer94415903_dormer
dorper94314573_dorper
dorser74819183_dorser
doser66228563_do_ser
dosser74417973_dosser
dote55442883_do_te_
doted75227073_do_ted
doters74423913_do_ters
dotes65836693_do_tes
dotier73917033_dotier
dotted84717523_dotted
dottel73610893_dottel
dotters83715973_dotters
dottier83910923_dottier
doubter10298353_doubter
dourer74215273_dourer
douser75621633_douser
dower95027703_do_wer
downer104414923_downer
dowser104716083_dowser
dozer158419273_do_zer
dozier163611633_dozier
dropper12329873dropper
duper85519003_dup_er
duster74919723_duster
eloper85414153elop_er
emoter85415193emo_ter
fagoter1135883fago_ter
floater104413353floater
flopper14328473flopper
flouter104311343flouter
footer94320773_footer
foster94322223_foster
fronter103611583fronter
garotter965943garotter
gloater83711013gloater
goiter74116203_goiter
goopier103910573goopier
gopher1239183_gopher
groper94517253grop_er
grouter84412523grouter
hooper114518313hoop_er
hoopster1335543hoopster
hooter94123933_hooter
hoper105829143_hop_er
hopper134218483_hopper
hotter94720083_hotter
idolater936863idolater
jolter133513093_jolter
jotter134315633_jotter
knotter11317643knotter
lofter94614723_lofter
loiter64619173_loiter
looper83817113loop_er
loopier93711193loopier
looter64222323_looter
loper75129233_lop_er
lopper103717203_lopper
lotter64025603_lotter
molter84119423_molter
mooter83921093_mooter
moper94925923_mop_er
mopier103914783_mopier
mopper126215003_mopper
noter55025643_no_ter
oater55433733__oater
odometer1147413odometer
ofter84116873__ofter
opted84914273__opted
otter54423973__otter
outer55633303__outer
oxter123414093__oxter
peopler1138083peopler
plotter94113663plotter
poofter1237163poofter
popper93615963_popper
porter84224413_porter
poster84129173_poster
potter83926983_potter
pouter83923983_pouter
powter114116033_powter
prompter1437983prompter
proper104319953prop_er
quoter153510093quo_ter
readopted1344913readopted
rioter64817283rio_ter
rooster74415173rooster
rooter64926033_rooter
roper75431913_rop_er
ropier84118803_ropier
roster64329083_roster
rotter64325463_rotter
router65025843_router
scepter1138363scepter
scooter93312873scooter
scoter83815483sco_ter
scouter93313323scouter
shooter103013993shooter
shopper143312633shopper
shorter103515503shorter
shouter103213083shouter
sloper84615913slop_er
slotter73314453slotter
snorter74412663snorter
softer94015313_softer
sorter64425093_sorter
souter64225923_souter
sporter93616553sporter
spotter94514883spotter
spouter94213223spouter
stoper84320103stop_er
stopper113012603stopper
stouter74012053stouter
sumpter1138873sumpter
swotter10399473swotter
tempter11358213tempter
tooter64420803_tooter
toper75231023_top_er
topper103817603_topper
toter55932133_to_ter
totter65021463_totter
touter63821033_touter
trotter73312253trotter
udometer1146333udometer
unadopted1344563unadopted
voter85121053_vo_ter
whopper17328503whopper
zoster153715853_zoster

Search took 7 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 Filter1786911340270.390458182.1
2DLD Change Limit1340272726.36021073.4
3Display Results2722720.1102472.7
 (SQL Overall)1786912726.86026048.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.