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

556 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
settled8321087(None) 
fettled11378931fettled
mettled103510541mettled
nettled8339941nettled
pettled103611501pettled
settle63915661settle_
settler73410651settler
settles73916001settles
battled104213122battled
beetled1038212beetled
betted94721162bett_ed
bottled104611232bottled
cuttled10319932cuttled
fetted104817892fett_ed
fettle93713122fettle_
fettles103912732fettles
gentled9389092gentled
guttled9378992guttled
jetted143915082jett_ed
jettied15366972jettied
kettle104311612kettle_
kettles113411612kettles
kittled12388192kittled
letted74118542lett_ed
metaled102913872metaled
mettle83815722mettle_
mettles94115022mettles
mottled10409972mottled
nestled8349902nestled
netted74118712nett_ed
nettle64514582nettle_
nettler7349502nettler
nettles73214082nettles
pestled102711432pestled
petaled103614142petaled
petted94121522pett_ed
pettle84116052pettle_
pettles93916482pettles
rattled84012952rattled
resettled1035292resettled
retiled84420512retiled
retitled9339552retitled
retted74826312rett_ed
scuttled1134532scuttled
sealed74328362se_aled
seated75131052seat_ed
seeled73922092se_eled
seethed113410192seethed
sepaled10510592sepaled
settee63721022sett_ee
settees73513632settees
setter64023722sett_er
settlers8289022settlers
settlor7314732settlor
shuttled1234662shuttled
sotted74121392sott_ed
staled74728102s_taled
steeled83513212steeled
stetted82610402stetted
stoled74521592s_toled
styled105613102s_tyled
tattled84311482tattled
unsettled1055212unsettled
vetted104316322vett_ed
vittled11347342vittled
wattled113610502wattled
wetted103717022wett_ed
abetted1058323abett_ed
batted95623653batt_ed
battle85217863battle_
battler94113383battler
battles94517683battles
beetle8311673beetle_
beetler938033beetler
beetles9312083beetles
belittled1243033belittled
belled94626183be_lled
belted94020633belt_ed
berthed13259123berthed
bested94922753best_ed
betaxed17307023betaxed
betided114810203betided
better84723703bett_er
bettered113011833bettered
beveled133811123beveled
bitted94418483bitt_ed
bottle84916073bottle_
bottler94211883bottler
bottles94216273bottles
brattled11196723brattled
brittled11186093brittled
bustled104011513bustled
butled94818603_butled
butted94722063butt_ed
castled104311513castled
catted95422473catt_ed
cattle85118903cattle_
ceiled94114953ce_iled
celled94420323ce_lled
centred103411683centred
cuittled1133993cuittled
cuttle84113893cuttle_
cuttles93613923cuttles
dartled9409853dartled
defiled124013103defiled
deled75326543de__led
dented84120513dent_ed
dentiled1039743dentiled
detailed10319873detailed
detoxed1636103detoxed
develed123611933develed
deviled124112183deviled
dittoed936733dittoed
dotted84717523dott_ed
dottle74212503dottle_
dottles83912283dottles
duetted937023duett_ed
eagled82914043_eagled
entitled967503entitled
estated83715573estated
etched123613703_etched
exiled144712463_exiled
fatted105419843fatt_ed
felled103720303fe_lled
felted103714653felt_ed
feruled11318413feruled
fetched163710473fetched
feted94420933fe_t_ed
fetter94120383fett_er
fettered12259493fettered
fitted104716663fitt_ed
footled113610763footled
fretted113411853frett_ed
gelled84718893ge_lled
gentle74014513gentle_
gentler8378953gentler
gentles83714343gentles
getter74117613gett_er
gettered10258613gettered
ghettoed1342083ghettoed
gitted84015053gitt_ed
gutted84716363gutt_ed
guttle74111973guttle_
guttler8369163guttler
guttles83011933guttles
hatted104921513hatt_ed
healed105121443he_aled
heated104525593heat_ed
heckled17318463heckled
heeled104018413he_eled
hefted134911423heft_ed
heiled104415613he_iled
helled104024703he_lled
hented104218753hent_ed
hotted104319933hott_ed
hurtled11339593hurtled
hustled113210133hustled
hutted104616333hutt_ed
insetted9249023insett_ed
intitled967343intitled
jelled144916063je_lled
jested144416503jest_ed
jettier14358693jettier
jetties143613123jetties
jeweled1845323jeweled
jostled15267083jostled
jotted143615173jott_ed
justled15338093justled
jutted144315023jutt_ed
juttied15417863juttied
keckled13376503keckled
keeled114414263ke_eled
kirtled12287033kirtled
kitted115114833kitt_ed
kittle104012173kittle_
kittler11338163kittler
kittles113012493kittles
letched133912053letched
letter63722583lett_er
lettered92910783lettered
leveled114010383leveled
little63312163little_
littler7348553littler
littles73212783littles
lotted74222403lott_ed
mantled104113393mantled
matted94521413matt_ed
measled10339303measled
meated94222403meat_ed
medaled113411603medaled
meddled123210023meddled
melled95023023me_lled
melted94219063melt_ed
metalled1148973metalled
meted85424433me_t_ed
metered103514013metered
metred95315143me_tred
mewled123710053me_wled
mottle84116053mottle_
mottler94410343mottler
mottles93415803mottles
needled9358513needled
nested74720063nest_ed
nestle63013953nestle_
nestler73510443nestler
nestles73015463nestles
netter63722023nett_er
nettier74211813nettier
nettlers8307513nettlers
nettlier864813nettlier
nettly9459453nettl_y
nutted74316973nutt_ed
outled74020343_outled
patted94724683patt_ed
pealed95322803pe_aled
pearled10411533pearled
pebbled1445393pebbled
pedaled113711873pedaled
peddled123410533peddled
peeled94119703pe_eled
pelted94617753pelt_ed
peopled1238483peopled
periled10316293periled
pestle83215843pestle_
pestles93217693pestles
petalled1138683petalled
petered103314963petered
petioled1137993petioled
petter83924773pett_er
pettier94213613pettier
pitted94319593pitt_ed
potted94624013pott_ed
pottle84416103pottle_
pottles93816983pottles
prattled11246533prattled
presettled1344073presettled
prettied1159253prettied
putted94220253putt_ed
puttied103811163puttied
ratted74923343ratt_ed
rattle64717613rattle_
rattler74012743rattler
rattles73217303rattles
rebottled1243433rebottled
reddled102912323reddled
reeled74725533re_eled
refiled114318653refiled
regaled93615953regaled
rented74426593rent_ed
reoiled84316853reoiled
repled93319773re_pled
resettle837303resettle_
resettles936563resettles
resiled84621983resiled
resoled84119283resoled
rested74430783rest_ed
restyled1236943restyled
retailed94113963retailed
retaped103814283retaped
retaxed153512233retaxed
retched133814273retched
retied75924983re_tied
retile65929673retile_
retiles74426993retiles
retimed104714653retimed
retired84620143retired
retitle73913093retitle_
retitles83612593retitles
retold73013753retol_d
retooled938473retooled
retotaled1045953retotaled
retried84419153retried
retuned86613973retuned
retyped13367303retyped
reveled113917753reveled
reviled114417923reviled
rootled83410533rootled
rotted74524433rott_ed
rustled83311323rustled
rutted74518403rutt_ed
saddled103112033saddled
sailed74327763s_ailed
salted74121203salt_ed
sampled123410783sampled
sated66238533s_at_ed
sauted74119603saut_ed
sauteed8349613sauteed
scaled94822443s_caled
scathed134012643scathed
scatted103512773scatted
scented102811883scent_ed
sceptred1343653sceptred
scowled13398183scowled
sculled102911693sculled
scuttle936463scuttle_
scuttles1056503scuttles
scythed16385303scythed
seabed95017693se_abed
sealer63928963se_aler
seamed94823883se_amed
seared75232843se_ared
seater64534153seat_er
seatless83213003seatless
seaweed11108813seaweed
seceded11319203seceded
sectile9311973sectile_
sectored1138063sectored
secured1059723secured
sedated93714343sedated
sedile73517233sedile_
seduced1186753seduced
seed55549483se___ed
seedbed11246613seedbed
seeded84520463se_eded
seemed95117613se_emed
seeped94317523se_eped
seethe93712483seethe_
seethes103613743seethes
segued838513se_gued
seined74023063se_ined
seised74218123se_ised
seized164313653se_ized
selfed10310913se_lfed
selle54428313se_lle_
seller63824593se_ller
selles64426983se_lles
seltzer1635203seltzer
semple103212753semple_
sended85121233se_nded
senile63420213senile_
seniles72618023seniles
sensed73918163se_nsed
sente56432873sent_e_
sepalled1156903sepalled
septet8921133sept_et
septupled1442083septupled
sered65737293se__red
serged84118763se_rged
serifed11811463serifed
serried82513963serried
served104616813se_rved
sestet6826203sest_et
setae56026223se_tae_
setal56430903setal__
setose65114773setose_
sett45949053sett___
setters73822063setters
setting83621393setting
settling978943settling
settlors8255003settlors
setts55124323sett__s
severed113513863severed
sewed95325163se__wed
sewered112911243sewered
sexed136618543se__xed
sextet13916873sext_et
sextile1438573sextile_
sextiles1537643sextiles
sextupled1942143sextupled
shaled105023953s_haled
shauled1148793shauled
shawled1437773shawled
sheathed1547213sheathed
sheeted113813033sheet_ed
sheetfed1544133sheetfed
shelled113815083shelled
shilled113313623shilled
shitted114212043shitted
shoaled113810963shoaled
shooled115212653shooled
shotted113912383shotted
shuted103913163shut_ed
shuttle1046093shuttle_
shuttler1164893shuttler
shuttles1136543shuttles
sickled144713433sickled
sidled84215173s_idled
sifted104313673sift_ed
silted74020013silt_ed
singled93914683singled
sited65130743s_it_ed
sitten64113823sitt_en
sitter63323383sitt_er
sizzled16367883sizzled
skated114414873skat_ed
sketched1835393sketched
skilled123110863skilled
skirled12348183skirled
skited114313473skit_ed
skittle1135523skittle_
skittles1245763skittles
skoaled12226043skoaled
skulled12317403skulled
slated75028313slat_ed
slatted84015183slatted
sled55334373s___led
sleeted83113223sleet_ed
sleuthed1233813sleuthed
slitted83513313slitted
slotted84613873slotted
smelled103511853smelled
smelted10399093smelt_ed
smiled93716433s_miled
smutted1037463smutted
snailed83811923snailed
snarled83612353snarled
snelled83313043snelled
snooled84513933snooled
soiled73822473s_oiled
soled65835173s__oled
sooted73922583soot_ed
soothed113712733soothed
sorted74523713sort_ed
sortied83314093sortied
souled75419823s_ouled
southed114313993southed
sozzled16265183sozzled
spalled103113123spalled
spathed134013183spathed
spatted104014143spatted
speckled17255823speckled
speeled103712453speeled
speiled104412123speiled
spelled103714733spelled
spieled104811883spieled
spiled94621993s_piled
spilled103613623spilled
spited94820443spit_ed
spitted103912703spitted
spittle937923spittle_
spittles1038333spittles
spoiled104811353spoiled
spooled104613523spooled
spotted103713133spotted
sprattled1263303sprattled
stabled103514953stabled
staged84521563s_taged
staked114621943s_taked
stale55637103s_tale_
staler64025823s_taler
stales65538293s_tales
stalked123811173s_talked
stalled83515683stalled
staned74824643s_taned
stapled103613693stapled
stared75429873s_tared
startled9208553startled
stated75427833s_tated
statued8459893statued
staved103918053s_taved
stayed104817273s_tayed
steaded92811673steaded
stealer72913973stealer
steamed103712143steamed
steed66024943s__teed
steeked124010473steeked
steeped103412283steeped
steepled1135893steepled
steered83615253steered
steeved113610133steeved
stele55026843s_tele_
steles63725663s_teles
stemmed12278153stemmed
stepped123210053stepped
sterlet71318473sterlet
stewed104814243s_tewed
stied65723033s__tied
stifled113511093stifled
stile54931573s_tile_
stiles64328763s_tiles
stilled83314773stilled
stilted83511473s_tilted
stiped94517073s_tiped
stoked114718293s_toked
stole54928813s_tole_
stolen64315063s_tolen
stoles63927673s_toles
stolid74213173s_tolid
stoned75923143s_toned
stooled84313893stooled
stoped94721013s_toped
stored75524213s_tored
stotted83511413stotted
stowed105817203s_towed
styed95815483s__tyed
style85519363s_tyle_
styler94013303s_tyler
styles94418653s_tyles
stylet94018573s_tylet
subtitled1244693subtitled
subtle82113433subtle_
subtler92910843subtler
suckled144212513suckled
suited74019423suit_ed
suppled1248463suppled
sutler63718393s_utler
suttee63721543sutt_ee
suttees74114063suttees
sutured8310373sutured
swathed144611933swathed
swatted114110693swatted
sweated113411543sweat_ed
swelled113211693swelled
swilled113611833swilled
swirled11308223swirled
swotted11398703swotted
tatted74920533tatt_ed
tattle64115653tattle_
tattler73112213tattler
tattles73616283tattles
teated74924023teat_ed
teazled17326833teazled
teethed11318623teethed
templed12278553templed
tented74221003tent_ed
tested74421523test_ed
tetched133010773tetched
tetter64322453tett_er
tiled64832943__tiled
titled73815003_titled
tittle63613323tittle_
tittles73413253tittles
toled65934923__toled
tootled83511043tootled
totaled839693totaled
totted74319953tott_ed
turtled8309683turtled
tutted75117443tutt_ed
twattled1273463twattled
unsettle866063unsettle_
unsettles964653unsettles
untitled978763untitled
vatted104214733vatt_ed
vealed103916323ve_aled
veiled103714543ve_iled
vented104617923vent_ed
vested104217353vest_ed
vetoed10359823ve_toed
vetter93417643vett_er
vittle94711753vittle_
vittles103211113vittles
wattle94314213wattle_
wattles103814073wattles
wedeled1237783wedeled
weeted103913793weet_ed
welled103820213we_lled
welted103715823welt_ed
wetter93919443wett_er
whetted14256693whett_ed
whittled1594913whittled
wintled11339843wintled
witted104216813witt_ed
wotted104115713wott_ed
wrestled12296763wrestled
yelled104116253ye_lled
zested164214043zest_ed

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 Filter1786911340270.1401276364.3
2DLD Change Limit1340275568.32616097.4
3Display Results5565560.2062699.0
 (SQL Overall)1786915568.67220605.5
 
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.