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

498 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
nettles7321408(None) 
fettles103912731fettles
kettles113411611kettles
mettles94115021mettles
nestles73015461nestles
nettle64514581nettle_
nettled8339941nettled
nettler7349501nettler
nettlers8307511nettlers
pettles93916481pettles
settles73916001settles
battles94517682battles
beetles9312082beetles
bottles94216272bottles
cuttles93613922cuttles
dottles83912282dottles
entitles8710662entitles
fettle93713122fettle_
fettled11378932fettled
gentles83714342gentles
guttles83011932guttles
jetties143613122jetties
kettle104311612kettle_
kittles113012492kittles
littles73212782littles
mettle83815722mettle_
mettled103510542mettled
mottles93415802mottles
needles83211562needles
nestle63013952nestle_
nestled8349912nestled
nestler73510452nestler
nestlers8359232nestlers
netless739862ne_tless
netted74118712nett_ed
netter63722022nett_er
netters73618582netters
nettier74211812nettier
nettiest83112432nettiest
nettlier864812nettlier
nettliest945412nettliest
nettly9459452nettl_y
netts55320722nett__s
pestles93217692pestles
pettle84116052pettle_
pettled103611512pettled
pottles93816982pottles
rattles73217302rattles
retiles74426992retiles
retitles83612592retitles
settees73513632settees
settle63915662settle_
settled83210872settled
settler73410652settler
settlers8289022settlers
tattles73616282tattles
tittles73413252tittles
unsettles964652unsettles
vittles103211112vittles
wattles103814072wattles
aediles83413903aediles
aneles64626293ane__les
anetholes1246673anetholes
battle85217863battle_
battled104213123battled
battler94113383battler
battlers104110973battlers
battues94610193battues
beadles103414733beadles
beagles103212123beagles
beatless103311593beatless
beetle8311673beetle_
beetled1038223beetled
beetler938043beetler
beetlers1037403beetlers
belittles1143873belittles
belles85325993be_lles
beltless10297713beltless
betakes134212523betakes
betels84515063betel_s
bethels1238533bethels
betides104915263betides
betimes115114413betimes
betises94816123betises
bettas84913923bett_as
betted94721163bett_ed
better84723703bett_er
betters94422093betters
bettors93312473bettors
bottle84916073bottle_
bottled104611233bottled
bottler94211883bottler
bottlers103810013bottlers
brattles10199333brattles
brittles10178653brittles
bustles93816323bustles
butles84423913_butles
buttes84822563butt_es
butties93217953butties
cantles94721413cantles
castles94917733castles
catties94023053catties
cattle85118903cattle_
centiles103615813centiles
centres93817123centres
certes84623083cert_es
cetanes9315133cetanes
cetes75731103ce_t_es
citoles9312553citoles
cuittles1045903cuittles
cutties93118843cutties
cuttle84113893cuttle_
cuttled10319933cuttled
dartles84014133dartles
debtless1135653debtless
deciles104417723deciles
deckles143312803deckles
defiles114016843defiles
deities82621923deities
deles65139253de__les
detoxes1538803detoxes
dinettes9310193dinett_es
ditties83116983ditties
dottels8327783dottels
dottle74212503dottle_
eagles73819163_eagles
ediles74016983_ediles
enables92813123enables
enates64026433enat_es
enisles72312603enisles
ensiles72714833ensiles
entases72816273entases
entices91616333entices
entires71517783entires
entities8617413entities
entitle7610293entitle_
entitled967503entitled
entrees71813773entrees
entries71523163entries
etapes85415293_etapes
etches114217763_etches
etoiles7411293_etoiles
etudes73811603_etudes
etwees9348793_etwees
exiles134816403_exiles
fatties103018203fatties
feetless1137383feetless
females12310663females
ferules103112723ferules
fetches153413893fetches
fetes85630143fe_t_es
fetiales11319613fetiales
fetted104817893fett_ed
fetter94120383fett_er
fetters103517903fetters
fetuses10310243fetuses
footles103715713footles
fyttes1236933fytt_es
genettes938303genett_es
gentes75324163gent_es
gentiles93713523gentiles
gentle74014513gentle_
gentled9389093gentled
gentler8378953gentler
gentlest93410573gentlest
gestes75721393gest_es
getter74117613gett_er
getters84216103getters
ghettoes1243493ghettoes
guttle74111973guttle_
guttled9378993guttled
guttler8369163guttler
guttlers9306933guttlers
hantles104117513hantles
heatless113011463heatless
heckles163711383heckles
heddles123311623heddles
hertzes1938303hertzes
hotties103016963hotties
hurtles103913753hurtles
hustles103414173hustles
intitles8710003intitles
istles62814983_istles
ixtles13217063_ixtles
jetes124922843je_t_es
jetted143915083jett_ed
jettied15366973jettied
jettier14358693jettier
jettiest15359593jettiest
jettons1437273jettons
jostles143411143jostles
justles143311433justles
jutties143814003jutties
keckles12318763keckles
kentes105118653kent_es
ketches164012193ketches
ketenes114813503ketenes
ketols104210763ketol_s
ketones115014503ketones
ketoses114912873ketoses
kirtles11309663kirtles
kitties113213623kitties
kittle104012173kittle_
kittled12388193kittled
kittler11338163kittler
kittlest12297573kittlest
lattes65324203latt_es
lefties10312073lefties
letches124015483letches
lethes94818083le_thes
letted74118543lett_ed
letter63722583lett_er
letters73819853letters
lettuces1043503lettuces
little63312163little_
littler7348553littler
littlest8309243littlest
lottes65322753lott_es
lunettes836753lunett_es
mantles94820703mantles
mattes85624533matt_es
measles92412753measles
meatless103410863meatless
meddles113213253meddles
mentees93214503mentees
merles85322763me_rles
mestees94617753mestees
metages102714973metages
metaled102913883metaled
metals84520883metal_s
metates92720013metates
metes74736213me_t_es
metols84115773metol_s
metopes11311363metopes
metres85121563me_tres
motiles93317433motiles
mottes85523693mott_es
mottle84116053mottle_
mottled10409973mottled
mottler94410343mottler
mottlers10388183mottlers
mottoes93412193mottoes
mutules9311843mutules
myrtles1235733myrtles
nasties73520493nasties
nates55238333n_at_es
nathless11127023nathless
natives10310823natives
natter64420743natt_er
natters73718063natters
nattier73614623nattier
nattiest83215353nattiest
natures7311963natures
navettes1136613navett_es
neaten64214543neat_en
neatens73310403neatens
neater64424313neat_er
neatest72516003neat_est
neatly93812483neatl_y
neatness839153neatness
neats55931903neat__s
nebulas957583nebulas
nebule848753nebule_
neckless14236433neckless
neckties1445903neckties
nectars938463nectars
neddies92710703neddies
needle73310613needle_
needled9358513needled
needler8388893needler
needlers9287423needlers
needless9308333needless
negates83215843negates
neguses837933neguses
neither1037573neither
nektons1136393nektons
nellies73418723nellies
nemeses948663nemeses
nenes55329673ne__nes
neotypes1344523neotypes
nerolis71012773nerolis
nerols6914883nerol_s
nerts55924983nert__s
nerves94216193ne_rves
nervules1145013nervules
nesses64718323ne_sses
nested74720063nest_ed
nester64124183nest_er
nesters74422793nesters
nestors73614973nestors
nests55728003nest__s
nether94014163ne_ther
netizen1635883netizen
netizens1743863netizens
netops839213ne_tops
nets45941533ne_t__s
netsukes1242793netsukes
nett46643233nett___
nettable101610243nettable_
netting84018763netting
nettings9288103nettings
nettlesome1252123nettlesome
nettling957213nettling
netty85816763nett__y
neumes83112623ne_umes
neuter63713793neut_er
neuters74212273neuters
neves87021873ne__ves
newbies12147423newbies
newels93710823newel_s
newies91014073ne_wies
newsies101310383newsies
newsless1134533newsless
newtons1036813newtons
newts86015283newt__s
nexuses1436743nexuses
nibbles114011693nibbles
nickles133713823nickles
nifties102612503nifties
niggles93512203niggles
nipples11319663nipples
nites55736343n_it_es
nitres65519333n_itres
nitriles8269923nitriles
nittier73512243nittier
nittiest82712603nittiest
nobbles114014523nobbles
nobles83319723n_obles
noctules1036583noctules
noddles92911293noddles
nodules8269703nodules
nombles113212343nombles
noodles83513193noodles
nopales93812523nopales
notables10178243notables
notates72817483notates
notches123513653notches
noteless839403noteless
notes55034583n_ot_es
notices9312283notices
nozzles15276303nozzles
nubbles113412433nubbles
numbles113814273numbles
nuncles939843nuncles
nutates73214973nutates
nutlet64220563n_utlet
nutlets74111253n_utlets
nutted74316973nutt_ed
nutter63918053nutt_er
nutters74215433nutters
nuttier73112023nuttier
nuttiest82312143nuttiest
nuzzles15298123nuzzles
patties93425143patties
pebbles1337573pebbles
peddles112913703peddles
peles75738083pe__les
peltless10267373peltless
peoples11312223peoples
pestle83215843pestle_
pestled102711453pestled
petaled103614153petaled
petals84719813petal_s
petioles10311643petioles
petites93820203petites
petrales10312983petrales
petrels9279373petrels
petted94121523pett_ed
petter83924773pett_er
petters93722363petters
pettier94213613pettier
pettiest103113963pettiest
pintles94118723pintles
potties93723543potties
pottle84416103pottle_
prattles10189403prattles
pretties10615133pretties
puttees93612913puttees
putties94420023putties
rattle64717613rattle_
rattled84012953rattled
rattler74012743rattler
rattlers83510293rattlers
reales64934123re_ales
rebottles1143873rebottles
reddles93315773reddles
refiles104122423refiles
regales83520793regales
rentes65431193rent_es
reptiles103913063reptiles
resales74724903resales
resettles936563resettles
resiles74026543resiles
resoles73823653resoles
restless82713163restless
restyles1139193restyles
retables101712673retables
retakes113718863retakes
retapes93917423retapes
retaxes143615093retaxes
retches123318513retches
retells73211523retells
retenes76324623retenes
reticles103912483reticles
reties65436193re_ties
retile65929673retile_
retiled84420513retiled
retimes95020173retimes
retines75134673retines
retires74726213retires
retitle73913093retitle_
retitled9339553retitled
retries74129073retries
retted74826313rett_ed
retunes76918403retunes
retypes12308623retypes
reviles104421353reviles
rootles73215633rootles
rottes64524833rott_es
rustles73416413rustles
rutiles74315843rutiles
scuttles1056503scuttles
seatless83213003seatless
seethes103613743seethes
selles64426983se_lles
seniles72618023seniles
settee63721023sett_ee
setter64023723sett_er
setters73822063setters
settlor7314733settlor
settlors8255013settlors
setts55124323sett__s
sextiles1537643sextiles
shuttles1136553shuttles
skittles1245763skittles
spittles1038333spittles
stales65538293_stales
steles63725663_steles
stiles64328773_stiles
stoles63927673_stoles
styles94418653_styles
suttees74114063suttees
tales55451373__tales
tatties74120343tatties
tattle64115653tattle_
tattled84311483tattled
tattler73112213tattler
tattlers8369693tattlers
teazles16308923teazles
teethes103611653teethes
teles54536003__teles
temples112610893temples
tentless8229843tentless
testees74215913testees
testes65125823test_es
tetter64322453tett_er
tetters74320473tetters
textiles1536833textiles
textless15245793textless
tiles55542103__tiles
titles63719923_titles
titties73617363titties
tittle63613323tittle_
toles55147133__toles
tonettes839203tonett_es
tootles72915603tootles
trestles83012553trestles
tules54532793__tules
turtles72914343turtles
tutties73216473tutties
twattles1154383twattles
unbottles1143463unbottles
unsettle866063unsettle_
unsettled1055213unsettled
ventless11249053ventless
venules104011483venules
vestees103513173vestees
vestless11258843vestless
vetches153411263vetches
vetoes92914083ve_toes
vetted104316323vett_ed
vetter93417643vett_er
vetters104016323vetters
vittle94711753vittle_
vittled11347343vittled
wattle94314213wattle_
wattled113610503wattled
wattless11268723wattless
wetted103717023wett_ed
wetter93919443wett_er
wetters103817753wetters
wettest10239363wett_est
whittles1496673whittles
wintles103414983wintles
wrestles113310063wrestles
yentes95517603yent_es
yetts86715133yett__s
zestless17247433zestless

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.406440125.6
2DLD Change Limit1340274986.28321331.7
3Display Results4984980.1862677.4
 (SQL Overall)1786914986.87525991.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.