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

418 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
settlers828902(None) 
nettlers8307511nettlers
setters73822061sett_ers
settler73410651settler_
settles73916001settle_s
settlors8255011settlors
battlers104110972battlers
beetlers1037402beetlers
betters94422092bett_ers
bottlers103810012bottlers
fetters103517902fett_ers
fettles103912732fettle_s
getters84216102gett_ers
guttlers9306932guttlers
kettles113411612kettle_s
letters73819852lett_ers
mettles94115022mettle_s
mottlers10388182mottlers
nestlers8359232nestlers
netters73618582nett_ers
nettler7349502nettler_
nettles73214082nettle_s
petters93722362pett_ers
pettles93916482pettle_s
rattlers83510292rattlers
sealers74323552se_alers
seaters74028942seat_ers
seatless83213002seatless
sellers73721322se_llers
seltzers1735062seltzers
settees73513632sett_ees
setter64023722sett_er_
settle63915662settle__
settled83210872settle_d
settlor7314732settlor_
shuttlers1254122shuttlers
sitters74221552sitt_ers
stealers83412212stealers
stylers10359352s_tylers
sutlers73116972s_utlers
tattlers8369692tattlers
tetters74320472tett_ers
vetters104016322vett_ers
wetters103817752wett_ers
abetters1057173abett_ers
aethers103614943ae_thers
antlers74014743_antlers
batters94626013batt_ers
battler94113383battler_
battles94517683battle_s
beaters94925043beat_ers
beatless103311593beatless
beetler938043beetler_
beetles9312083beetle_s
belittlers1242023belittlers
belters93819413belt_ers
beltless10297713beltless
besetters11136643besett_ers
betatters1134963betatters
better84723703bett_er_
bettors93312473bett_ors
bevelers13389463bevelers
bitters94920363bitt_ers
bottler94211883bottler_
bottles94216273bottle_s
bustlers104210623bustlers
butlers94518053_butlers
butters94521723butt_ers
ceilers93912533ce_ilers
centers94420603cent_ers
centners1057243centners
cotters94323443cott_ers
cottiers10399153cottiers
cutlers94217003_cutlers
cutters94218963cutt_ers
cuttles93613923cuttle_s
dealers84118613de_alers
debtless1135653debtless
defilers12439473defilers
detailers10257253detailers
deters74724683de_t_ers
dotters83715973dott_ers
dottles83912283dottle_s
eaters65535953_eat_ers
enters64425643_ent_ers
esters64627733_est_ers
estovers1136453estovers
etchers123411293_etchers
ethers94518413_e_thers
exilers14419733_exilers
feathers143513243feathers
feelers103814743fe_elers
feetless1137383feetless
fellers104117543fe_llers
festers104121393fest_ers
fetchers16328863fetchers
fetter94120383fett_er_
fetterers12267043fetterers
fettle93713123fettle__
fettled11378933fettle_d
fitters104517753fitt_ers
footlers113910793footlers
fretters113410303frett_ers
gentler8378953gentler_
gentles83714343gentle_s
getter74117613gett_er_
gutters83715513gutt_ers
guttler8369163guttler_
guttles83011933guttle_s
hatters104221523hatt_ers
healers104319463he_alers
heaters104225223heat_ers
heathers143914733heathers
heatless113011463heatless
hecklers17357123hecklers
heelers103815623he_elers
hefters134312003heft_ers
hellers103619833he_llers
hitters104717593hitt_ers
hostlers113310483hostlers
hustlers11349203hustlers
insetters9187133insett_ers
jesters144118193jest_ers
jettier14358693jettier_
jetties143613123jettie_s
jewelers1834713jewelers
jitters144314473jitt_ers
jostlers15357683jostlers
jotters143413803jott_ers
kegelers1355163kegelers
keglers12277773ke_glers
kelters113813753kelt_ers
kettle104311613kettle__
kittler11338163kittler_
kittles113012493kittle_s
leathers114215083leathers
letter63722583lett_er_
letterers9228113letterers
levelers11259323levelers
litters73422573litt_ers
littler7348553littler_
littles73212783little_s
lotters73921063lott_ers
matters94421753matt_ers
meatless103410863meatless
meddlers12318203meddlers
meeters94714543meet_ers
melters93918313melt_ers
metamers1249623metamers
meters85625833me_t_ers
metiers93312843me_tiers
mettle83815723mettle__
mettled103510543mettle_d
mewlers12288983me_wlers
mottler94410343mottler_
mottles93415803mottle_s
mutters94117143mutt_ers
natters73718063natt_ers
needlers9287423needlers
nesters74422793nest_ers
nestler73510453nestler_
nestles73015463nestle_s
netless739863ne_tless
netter63722023nett_er_
nettier74211813nettier_
nettle64514583nettle__
nettled8339943nettle_d
nettlier864813nettlier_
neuters74212273neut_ers
nutters74215433nutt_ers
ostlers72911203_ostlers
otters64021513_ott_ers
patters94825193patt_ers
pearlers1039033pearlers
pedalers11239393pedalers
peddlers12298533peddlers
pedlers103013273pe_dlers
peelers93615593pe_elers
pelters93720313pelt_ers
peltless10267373peltless
peoplers1237163peoplers
pesters93827093pest_ers
pestles93217693pestle_s
peters86624593pe_t_ers
petter83924773pett_er_
pettier94213613pettier_
pettle84116053pettle__
pettled103611513pettle_d
pewters124113353pewt_ers
potters94024343pott_ers
pottles93816983pottle_s
prattlers11195323prattlers
putters94219193putt_ers
puttiers10288013puttiers
ratters74422473ratt_ers
rattler74012743rattler_
rattles73217303rattle_s
realters83614043realters
reelers73520273re_elers
regalers94311133regalers
renters74224813rent_ers
rentiers83311763rentiers
resetters9129463resett_ers
resettles936563resettle_s
resters74130403rest_ers
restless82713163restless
retailers9258773retailers
retakers123511133retakers
retiles74426993retile_s
retirers84311533retirers
retitles83612593retitle_s
reutters8138573reutters
revelers113414133revelers
revilers114011693revilers
ritters74020623ritt_ers
rotters74421393rott_ers
rustlers8339853rustlers
saddlers10289753saddlers
sailers73822323s_ailers
salters73622253salt_ers
saltiers83411953saltiers
saltless8259343saltless
samplers12299403samplers
scalers93817263s_calers
scatters103612753scatters
scentless1135113scentless
scepters1237793scept_ers
scoters93313813scot_ers
scowlers13257373scowlers
scullers103510483scullers
scutters103311023scutters
scuttles1056503scuttle_s
sealer63928963se_aler_
sealery104011053se_alery
seamers94719433se_amers
seamless10238723seamless
seater64534163seat_er_
seceders11277963seceders
sectors93116453sect_ors
seculars10219393seculars
securers1057153securers
seders74420283se__ders
seducers1145383seducers
seeders83017113se_eders
seedless9319513seedless
seekers113712333se_ekers
seemers93814333se_emers
seers55136383se___ers
seethes103613743seethe_s
seiners74219273se_iners
seisers73816393se_isers
seizers164112503se_izers
selfless1135013selfless
seller63824603se_ller_
selles64426983se_lle_s
seltzer1635213seltzer_
senders83022353se_nders
seniles72618023senile_s
septets998953sept_ets
sergers83815633se_rgers
servers103214833se_rvers
sestets7911473sest_ets
settee63721023sett_e_e
settings93810073settings
settling978943settling
settlings1054683settlings
setts55124323sett___s
setulous846913setulous
severs94121123se__vers
sewers94719723se__wers
sexless1467243se_xless
sextets1497143sext_ets
sextiles1537643sextile_s
shatters113313913shatters
sheathers1557553sheathers
sheeters113111863sheet_ers
sheetless1235823sheetless
shellers112812583shellers
shelters113412813shelt_ers
shitless11249243shitless
shutters113611353shutters
shuttler1164903shuttler_
shuttles1136553shuttle_s
sidlers83414233s_idlers
sifters103714793sift_ers
sillers73822103s_illers
sinters74024083sint_ers
sisters73721593sist_ers
sitter63323383sitt_er_
sizzlers16274753sizzlers
skaters113512963skat_ers
skeeters12298963skeet_ers
skelters12349373skelt_ers
sketchers1834513sketchers
skitters12349553skitters
skittles1245763skittle_s
slaters73123733slat_ers
slathers113914783slathers
slithers114212953slithers
slitless8268143slitless
slitters84014133slitters
slotters84012403slotters
smatters104011713smatters
smellers10329773smellers
smelters103310513smelt_ers
smilers94113853s_milers
smiters93414363smit_ers
smithers13369793smithers
smothers13349933smothers
snarlers8298753snarlers
soothers113913433soothers
sorters74221133sort_ers
souters74422603sout_ers
southers114214453southers
spallers102910733spallers
spatters103914703spatters
specters122811063spect_ers
spellers102812763spellers
spelters103912243spelt_ers
spielers10319653spielers
spillers103311703spillers
spitters104113383spitters
spittles1038333spittle_s
spoilers10238633spoilers
spoolers10349363spoolers
spotless1037043spotless
spotters104313383spotters
sputters104012873sputters
stablers103611153stablers
stagers84116673s_tagers
staler64025823s_taler_
stales65538293s_tale_s
stalkers12369853s_talkers
staplers103111203staplers
starers74522313s_tarers
startlers9236743startlers
staters73922343s_taters
stayers103813633s_tayers
stealer72913983stealer_
steamers103410873steamers
steepers103011373steepers
steerers82511353steerers
steers63820983s__teers
steles63725663s_tele_s
stemless1036653stemless
stemmers12378443stemmers
steppers12289283steppers
sterlets8169273sterlets
stiflers11238833stiflers
stiles64328773s_tile_s
stivers103613543s_tivers
stokers114515183s_tokers
stoles63927673s_tole_s
stoners74817953s_toners
stopers94217373s_topers
storers75018683s_torers
stovers103713733s_tovers
stutters83210473stutters
styler94013303s_tyler_
styles94418653s_tyle_s
stylets10369213s_tylets
subtler92910843subtler_
sucklers14379963sucklers
suiters73618883suit_ers
sutler63718393s_utler_
suttees74114063sutt_ees
swathers144512083swathers
swatters113911793swatters
sweaters113811063sweat_ers
swelters113110193swelt_ers
swillers11299113swillers
swithers144310533swithers
swotters11448483swotters
talers64628143__talers
tatters74520483tatt_ers
tattler73112213tattler_
tattles73616283tattle_s
teeters74018303teet_ers
teethers11328713teethers
tellers73717603te_llers
tenters73921103tent_ers
tentless8229843tentless
testers74124543test_ers
tethers103815313te_thers
tetter64322453tett_er_
textless15245793textless
tilers63523503__tilers
titters74219623titt_ers
tittles73413253tittle_s
tootlers8289503tootlers
totters74618733tott_ers
turtlers8258203turtlers
unsettles964653unsettle_s
upsetters1143653upsett_ers
utters63817123_utt_ers
vealers103214293ve_alers
veilers103911823ve_ilers
venters103717733vent_ers
ventless11249053ventless
vestless11258843vestless
vetivers1435163vetivers
vetoers10359473ve_toers
vetter93417643vett_er_
vittles103211113vittle_s
wattles103814073wattle_s
wattless11268723wattless
weathers143412833weathers
welters103516063welt_ers
westers105221963west_ers
wethers135214693we_thers
wetter93919443wett_er_
whetters14246653whett_ers
whittlers1594333whittlers
wrestlers12306103wrestlers
yatters103914623yatt_ers
yellers103912953ye_llers
zesters163517293zest_ers
zestless17247433zestless

Search took 9 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.423422437.4
2DLD Change Limit1461624188.18617855.1
3Display Results4184180.1732416.2
 (SQL Overall)1786914188.78220347.4
 
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.