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

433 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
fettled1137893(None) 
fetted104817891fett_ed
fettle93713121fettle_
fettles103912731fettles
mettled103510541mettled
nettled8339941nettled
pettled103611501pettled
settled83210871settled
battled104213122battled
beetled1038212beetled
betted94721162bett_ed
bottled104611232bottled
cuttled10319932cuttled
fatted105419842fatt_ed
felled103720302fe_lled
felted103714652felt_ed
feruled11318412feruled
fetched163710472fetched
feted94420932fe_t_ed
fetter94120382fett_er
fettered12259492fettered
fitted104716662fitt_ed
footled113610762footled
fretted113411852frett_ed
gentled9389092gentled
guttled9378992guttled
jetted143915082jett_ed
jettied15366972jettied
kettle104311612kettle_
kettles113411612kettles
kittled12388192kittled
letted74118542lett_ed
metaled102913882metaled
mettle83815722mettle_
mettles94115022mettles
mottled10409972mottled
nestled8349902nestled
netted74118712nett_ed
nettle64514582nettle_
nettler7349502nettler
nettles73214082nettles
pestled102711432pestled
petaled103614142petaled
petted94121522pett_ed
pettle84116052pettle_
pettles93916482pettles
rattled84012952rattled
retiled84420512retiled
retitled9339552retitled
retted74826312rett_ed
settle63915662settle_
settler73410652settler
settles73916002settles
tattled84311482tattled
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
etched123613703_etched
exiled144712463_exiled
fabled124216383f_abled
facetted1445743facett_ed
failed105421603f_ailed
faithed1437163faithed
farted105121783fart_ed
fartlek1434493fartlek
fasted105320953fast_ed
fated95632133f_at_ed
fatten94314903fatt_en
fattened12268283fattened
fatter94523213fatt_er
fattier103513463fattier
fatties103018203fatties
faulted11227723faulted
feared106320433fe_ared
feased105718713fe_ased
feasted11310843feasted
feater95224053feat_er
feather133613503feather
featlier1136453featlier
featly123711753featl_y
featured1237683featured
feazed195112633fe_azed
fedexed1934073fedexed
feeble1138253feeble_
feebler1235823feebler
feed84538903fe___ed
feeler93215173fe_eler
feetless1137383feetless
feezed19439993fe_ezed
feigned1245353feigned
feinted11379623feinted
felid94717173fe__lid
feller94419553fe_ller
female11310553female_
females12310663females
fenagled13184853fenagled
fenced124412713fe_nced
fended114216913fe_nded
feoffed1332813feoffed
ferreled1234833ferreled
ferried113411523ferried
ferruled1263923ferruled
fertile10311733fertile_
ferule93413203ferule_
ferules103112723ferules
fessed104515063fe_ssed
fester94723513fest_er
festered122512103festered
fetal85623373fetal__
fetcher153510393fetcher
fetches153413893fetches
fete75734923fe_t_e_
fetes85630143fe_t_es
fetiales11319613fetiales
fetid93715983fe_t_id
fetterer11207813fetterer
fetters103517903fetters
fetting113517873fetting
fettling1266773fettling
fetuses10310243fetuses
feuded114010003fe_uded
feued94715663fe__ued
fevered14339723fevered
fezzed18398243fe_zzed
fiddled13329633fiddled
filed95331903f__iled
filled104922263f_illed
fisted104218703fist_ed
fitter94120033fitt_er
fizzled19357273fizzled
flailed1137303flailed
flatbed13397983flatbed
flatlet10312253flatlet
flatted114012943flatted
fled85429773f___led
fleeted113310233fleet_ed
fletched17306693fletched
flited104616583flit_ed
flitted114011643flitted
fluted104917163flut_ed
flyted13378773flyt_ed
foaled104515963f_oaled
foiled104618403f_oiled
fondled12399423fondled
fooled104317823f_ooled
footed104418623foot_ed
footle93914383footle_
footler104011873footler
footles103715713footles
foozled20346893foozled
fouled104315973f_ouled
fowled133914093f_owled
freckled18104443freckled
fretter103412753frett_er
frettier1156593frettier
frilled113911603frilled
fritted113611333fritted
frothed14288783frothed
fuddled13309393fuddled
fueled104913603f_ueled
fuelled11369193fuelled
fugled114813693f_ugled
fulled103820653f_ulled
fumbled153710493fumbled
furled104717053f_urled
futile93914953futile_
futzed19418983f_utzed
fytte1138583fytt_e_
fyttes1236933fytt_es
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
hotted104319943hott_ed
hurtled11339593hurtled
hustled113210133hustled
hutted104616333hutt_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
medaled113411613medaled
meddled123210033meddled
melled95023023me_lled
melted94219063melt_ed
metalled1148983metalled
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
pearled10411543pearled
pebbled1445393pebbled
pedaled113711883pedaled
peddled123410533peddled
peeled94119703pe_eled
pelted94617753pelt_ed
peopled1238493peopled
periled10316303periled
pestle83215843pestle_
pestles93217693pestles
petalled1138693petalled
petered103314963petered
petioled1137993petioled
petter83924773pett_er
pettier94213613pettier
pitted94319593pitt_ed
potted94624013pott_ed
pottle84416103pottle_
pottles93816983pottles
prattled11246533prattled
prettied1159253prettied
putted94220253putt_ed
puttied103811163puttied
ratted74923343ratt_ed
rattle64717613rattle_
rattler74012743rattler
rattles73217303rattles
rebottled1243433rebottled
reddled102912323reddled
reeled74725533re_eled
refiled114318653refiled
regaled93615963regaled
rented74426593rent_ed
reoiled84316853reoiled
repled93319773re_pled
resettled1035303resettled
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
scuttled1134533scuttled
sealed74328363se_aled
seated75131053seat_ed
seeled73922093se_eled
seethed113410193seethed
sepaled10510593sepaled
settee63721023sett_ee
settees73513633settees
setter64023723sett_er
settlers8289023settlers
settlor7314733settlor
shuttled1234673shuttled
sotted74121403sott_ed
staled74728103_staled
steeled83513213steeled
stetted82610403stetted
stoled74521593_stoled
styled105613103_styled
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
unsettled1055213unsettled
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 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.1701051123.5
2DLD Change Limit1340274336.47020715.1
3Display Results4334330.1702547.1
 (SQL Overall)1786914336.81026239.5
 
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.