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

315 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
nettlers830751(None) 
nestlers8359221nestlers
netters73618581nett_ers
nettler7349501nettler_
nettles73214081nettle_s
settlers8289021settlers
battlers104110972battlers
beetlers1037392beetlers
betters94422092bett_ers
bottlers103810012bottlers
fetters103517902fett_ers
fettles103912732fettle_s
getters84216102gett_ers
guttlers9306932guttlers
kettles113411612kettle_s
letters73819852lett_ers
mettles94115022mettle_s
mottlers10388182mottlers
natters73718062natt_ers
needlers9287422needlers
nesters74422792nest_ers
nestler73510442nestler_
nestles73015462nestle_s
netless739862ne_tless
netter63722022nett_er_
nettier74211812nettier_
nettle64514582nettle__
nettled8339942nettle_d
nettlier864812nettlier_
neuters74212272neut_ers
nutters74215432nutt_ers
petters93722362pett_ers
pettles93916482pettle_s
rattlers83510292rattlers
setters73822062sett_ers
settler73410652settler_
settles73916002settle_s
settlors8255012settlors
tattlers8369692tattlers
tetters74320472tett_ers
vetters104016322vett_ers
wetters103817752wett_ers
abetters1057173abett_ers
aethers103614943ae_thers
antlers74014743_antlers
batters94626013batt_ers
battler94113383battler_
battles94517683battle_s
beaters94925043beat_ers
beatless103311593beatless
beetler938033beetler_
beetles9312083beetle_s
belittlers1242023belittlers
belters93819413belt_ers
beltless10297713beltless
betatters1134963betatters
better84723703bett_er_
bettors93312473bett_ors
bevelers13389453bevelers
bitters94920363bitt_ers
bottler94211883bottler_
bottles94216273bottle_s
bustlers104210613bustlers
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
enablers10196913enablers
enfetters1244463enfett_ers
entailers976413entailers
enterers82214153enterers
enters64425643_ent_ers
enticers10139093enticers
entitles8710663entitle_s
esters64627733_est_ers
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
kneelers12226213kne_elers
knitters12336623knitt_ers
knotters12276153knott_ers
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
nailers73215893n_ailers
nathless11127023nathless
natter64420743natt_er_
nattier73614623nattier_
neatens73310403neat_ens
neater64424313neat_er_
neatherd12107193neatherd
neatherds1395773neatherds
neatness839153neatness
neckers134210463ne_ckers
neckless14236433neckless
nectars938463nect_ars
needers84111903ne_eders
needler8388893needler_
needles83211563needle_s
needless9308333needless
negaters9349783negaters
neither1037573neither_
nester64124183nest_er_
nestle63013953nestle__
nestled8349903nestle_d
nestors73614973nest_ors
nether94014163ne_ther_
netizens1743863netizens
netted74118713nett_e_d
nettiest83112433nettiest
nettings9288103nettings
nettliest945413nettliest
nettling957213nettling
nettly9459453nettl__y
netts55320723nett___s
neuter63713793neut_er_
newsless1134533newsless
nibblers12306543nibblers
nigglers10307253nigglers
niters64624213n_it_ers
nittier73512243nittier_
nobblers12318563nobblers
northers1139333northers
notchers13279423notchers
noteless839403noteless
noters64021003n_ot_ers
noticers1035693noticers
nutlets74111253n_utlets
nutter63918053nutt_er_
nuttier73112023nuttier_
nuzzlers16244753nuzzlers
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
resters74130403rest_ers
restless82713163restless
retailers9258773retailers
retakers123511133retakers
retiles74426993retile_s
retirers84311533retirers
retitles83612593retitle_s
reutters8138573reutters
revelers113414133revelers
revilers114011693revilers
ritters74020623ritt_ers
rotters74421393rott_ers
rustlers8339853rustlers
sealers74323553se_alers
seaters74028943seat_ers
seatless83213003seatless
sellers73721313se_llers
seltzers1735063seltzers
settees73513633sett_ees
setter64023723sett_er_
settle63915663settle__
settled83210873settle_d
settlor7314733settlor_
shuttlers1254123shuttlers
sitters74221553sitt_ers
stealers83412203stealers
stylers10359353_stylers
sutlers73116973_sutlers
talers64628143__talers
tatters74520483tatt_ers
tattler73112213tattler_
tattles73616283tattle_s
teeters74018303teet_ers
teethers11328713teethers
tellers73717593te_llers
tenters73921103tent_ers
tentless8229843tentless
testers74124543test_ers
tethers103815313te_thers
tetter64322453tett_er_
textless15245793textless
tilers63523503__tilers
titters74219623titt_ers
tittles73413253tittle_s
tootlers8289503tootlers
totters74618733tott_ers
turtlers8258203turtlers
unfetters1244363unfett_ers
unsettles964653unsettle_s
untethers1244153untethers
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 Limit1461623157.50019488.3
3Display Results3153150.1232561.0
 (SQL Overall)1786913158.04622208.7
 
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.