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

404 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
nettled833994(None) 
fettled11378931fettled
mettled103510541mettled
nestled8349911nestled
netted74118711nett_ed
nettle64514581nettle_
nettler7349501nettler
nettles73214081nettles
pettled103611511pettled
settled83210871settled
battled104213122battled
beetled1038222beetled
betted94721162bett_ed
bottled104611232bottled
cuttled10319932cuttled
entitled967502entitled
fetted104817892fett_ed
fettle93713122fettle_
fettles103912732fettles
gentled9389092gentled
guttled9378992guttled
jetted143915082jett_ed
jettied15366972jettied
kettle104311612kettle_
kettles113411612kettles
kittled12388192kittled
letted74118542lett_ed
metaled102913882metaled
mettle83815722mettle_
mettles94115022mettles
mottled10409972mottled
needled9358512needled
nested74720062nest_ed
nestle63013952nestle_
nestler73510452nestler
nestles73015462nestles
netter63722022nett_er
nettier74211812nettier
nettlers8307512nettlers
nettlier864812nettlier
nettly9459452nettl_y
nutted74316972nutt_ed
pestled102711452pestled
petaled103614152petaled
petted94121522pett_ed
pettle84116052pettle_
pettles93916482pettles
rattled84012952rattled
retiled84420512retiled
retitled9339552retitled
retted74826312rett_ed
settle63915662settle_
settler73410652settler
settles73916002settles
tattled84311482tattled
unsettled1055212unsettled
vetted104316322vett_ed
vittled11347342vittled
wattled113610502wattled
wetted103717022wett_ed
abetted1058323abett_ed
aneled74719283ane__led
batted95623653batt_ed
battle85217863battle_
battler94113383battler
battles94517683battles
beetle8311673beetle_
beetler938043beetler
beetles9312083beetles
belittled1243033belittled
belled94626193be_lled
belted94020633belt_ed
berthed13259123berthed
bested94922763best_ed
betaxed17307023betaxed
betided114810203betided
better84723703bett_er
bettered113011843bettered
beveled133811133beveled
bitted94418483bitt_ed
bottle84916073bottle_
bottler94211883bottler
bottles94216273bottles
brattled11196723brattled
brittled11186093brittled
bustled104011523bustled
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
enabled102510633enabled
enisled82510223enisled
ensiled82611433ensiled
entailed989523entailed
entered82718883entered
enticed101411193enticed
entitle7610293entitle_
entitles8710663entitles
entoiled968283entoiled
etched123613703_etched
exiled144712463_exiled
fatted105419843fatt_ed
felled103720303fe_lled
felted103714653felt_ed
feruled11318423feruled
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
hotted104319943hott_ed
hurtled11339593hurtled
hustled113210133hustled
hutted104616333hutt_ed
insetted9249023insett_ed
intitled967343intitled
jelled144916063je_lled
jested144416503jest_ed
jettier14358693jettier
jetties143613123jetties
jeweled1845333jeweled
jostled15267083jostled
jotted143615173jott_ed
justled15338093justled
jutted144315023jutt_ed
juttied15417863juttied
keckled13376503keckled
keeled114414273ke_eled
kirtled12287033kirtled
kitted115114833kitt_ed
kittle104012173kittle_
kittler11338163kittler
kittles113012493kittles
kneeled12328073kne_eled
knelled12338993kne_lled
knitted12337423knitt_ed
knotted12357233knott_ed
letched133912053letched
letter63722583lett_er
lettered92910783lettered
leveled114010383leveled
little63312163little_
littler7348553littler
littles73212783littles
lotted74222403lott_ed
mantled104113393mantled
matted94521413matt_ed
measled10339303measled
meated94222403meat_ed
medaled113411613medaled
meddled123210033meddled
melled95023023me_lled
melted94219063melt_ed
metalled1148993metalled
meted85424433me_t_ed
metered103514013metered
metred95315143me_tred
mewled123710053me_wled
mottle84116053mottle_
mottler94410343mottler
mottles93415803mottles
nailed74021493n_ailed
naled65525053n__aled
natter64420743natt_er
nattered92011623nattered
nattier73614623nattier
natured838963natured
neared75119803ne_ared
neaten64214543neat_en
neatened937043neatened
neater64424313neat_er
neatherd12107193neatherd
neatly93812483neatl_y
nebule848753nebule_
necked134715063ne_cked
need54934153ne___ed
needed84114443ne_eded
needle73310613needle_
needler8388893needler
needles83211563needles
negated93413233negated
neighed12135893neighed
neither1037573neither
neoned7311483ne_oned
nerved104111683ne_rved
nester64124183nest_er
nestlers8359233nestlers
nether94014163ne_ther
netizen1635883netizen
netless739863ne_tless
nett46643233nett___
nettable101610243nettable_
netters73618583netters
nettiest83112433nettiest
netting84018763netting
nettliest945413nettliest
nettling957213nettling
netts55320723nett__s
netty85816763nett__y
neuter63713793neut_er
neutered937423neutered
nibbled12389073nibbled
nickled144010443nickled
niggled10319203niggled
nilled73919453n_illed
nippled12307643nippled
nittier73512243nittier
nobbled123511283nobbled
noddled10358563noddled
noodled9339923noodled
notated82713663notated
notched134210303notched
noted65123843n_ot_ed
noticed1037863noticed
nulled74318273n_ulled
nurled74016233n_urled
nutated83113423nutated
nutlet64220563n_utlet
nutter63918053nutt_er
nuttier73112023nuttier
nuzzled16276393nuzzled
outled74020343_outled
patted94724683patt_ed
pealed95322813pe_aled
pearled10411553pearled
pebbled1445403pebbled
pedaled113711893pedaled
peddled123410543peddled
peeled94119713pe_eled
pelted94617763pelt_ed
peopled1238503peopled
periled10316323periled
pestle83215843pestle_
pestles93217693pestles
petalled1138713petalled
petered103314973petered
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
repled93319783re_pled
resettled1035303resettled
resiled84621983resiled
resoled84119283resoled
rested74430783rest_ed
restyled1236953restyled
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
seated75131063seat_ed
seeled73922093se_eled
seethed113410193seethed
sepaled10510593sepaled
settee63721023sett_ee
settees73513633settees
setter64023723sett_er
settlers8289023settlers
settlor7314733settlor
shuttled1234673shuttled
snelled83313053sne_lled
sotted74121403sott_ed
staled74728103_staled
steeled83513223steeled
stetted82610403stetted
stoled74521593_stoled
styled105613103_styled
tatted74920533tatt_ed
tattle64115653tattle_
tattler73112213tattler
tattles73616283tattles
teated74924023teat_ed
teazled17326833teazled
teethed11318623teethed
templed12278563templed
tented74221003tent_ed
tested74421523test_ed
tetched133010773tetched
tetter64322453tett_er
tiled64832943__tiled
titled73815003_titled
tittle63613323tittle_
tittles73413253tittles
toled65934923__toled
tootled83511043tootled
totaled839693totaled
totted74319953tott_ed
turtled8309683turtled
tutted75117443tutt_ed
twattled1273463twattled
unbottled1244153unbottled
unletted9310313unlett_ed
unsettle866063unsettle_
unsettles964653unsettles
untitled978763untitled
unwetted1238123unwett_ed
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 8 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.403443402.0
2DLD Change Limit1340274046.73619897.1
3Display Results4044040.1402885.7
 (SQL Overall)1786914047.27924548.8
 
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.