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

382 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
needles8321156(None) 
needle73310611needle_
needled9358511needled
needler8388891needler
needlers9287421needlers
needless9308331needless
beadles103414732beadles
beedies10314202beedies
beetles9312082beetles
deedless10318252deedless
heddles123311622heddles
heedless12278812heedless
meddles113213252meddles
neddies92710702neddies
needed84114442need_ed
needer73614952need_er
needers84111902needers
needier84010622needier
neediest92611302neediest
needs65719632need__s
nestles73015462nestles
nettles73214082nettles
noddles92911292noddles
noodles83513192noodles
peddles112913702peddles
reddles93315772reddles
seedless9319512seedless
tweedles1234112tweedles
weedless12287962weedless
wheedles1534652wheedles
abeles84719393abe_les
addles84216603_addles
aedes64625153_aed_es
aediles83413903aediles
aneles64626293ane_les
areoles71016953areoles
beadle93314683beadle_
beagles103212123beagles
bedells10379363bedells
bedels94015273bedel_s
bedless1039703_bedless
beebees1138013beebees
beeches143413883beeches
beefless1335493beefless
beetle8311673beetle_
beetled1038223beetled
beetler938043beetler
beetlers1037403beetlers
beeves114615043bee_ves
belles85325993_belles
bendees103913863bendees
bindles104016453bindles
boodles103416043boodles
bredes94818473bred_es
bridles104114473bridles
buddles113913073buddles
bundles103515773bundles
candles104422343candles
caudles103912813caudles
cedes84927333_ced_es
coddles114213593coddles
cradles103114133cradles
creoles9913323creoles
cuddles114014093cuddles
curdles103814573curdles
daddles104213803daddles
dandles94218533dandles
dawdles12379163dawdles
deciles104417723deciles
deckles143312803deckles
deeded94615543deed_ed
deedier93011593deedier
deediest102912253deediest
deeds75423763deed__s
defiles114016843defiles
deles65139253_de_les
diddles103915073diddles
dindles93817243dindles
doodles93614163doodles
dredges10379353dredges
eagles73819163_eagles
eddies83313163_eddies
eddoes8199143_eddoes
edges75718743__edges
ediles74016983_ediles
eels46536743_ee_l_s
enables92813123enables
endless839833_endless
endues73813903_endues
enemies9313693enemies
enfeebles14152723enfeebles
enisles72312603enisles
ensiles72714833ensiles
exiles134816403_exiles
fedexes1835473fedexes
feeble1138253feeble_
feebler1235823feebler
feeblest1336913feeblest
feeder103513843feed_er
feeders113712863feeders
feedholes1643963feedholes
feedlot11135933feedlot
feedlots12144453feedlots
feeds94921143feed__s
feeler93215173fee_ler
feelers103814743fee_lers
feeless103511103fee_less
feels85223043fee_l_s
feetless1137383feetless
feezes184412613fee_zes
females12310663females
ferules103112723ferules
fettles103912733fettles
fiddles123212603fiddles
fledges12409393fledges
fondles113512613fondles
fuddles123611933fuddles
gentles83714343gentles
geodes8412153geod_es
girdles92210003girdles
gledes84915133gled_es
greedless1144893greedless
handles114020653handles
headless12289863headless
heckles163711383heckles
heddle114211163heddle_
hedges115016263_hedges
heeded114215763heed_ed
heeder104216043heed_er
heeders114213743heeders
heeds95420423heed__s
heeled104018423hee_led
heeler93917323hee_ler
heelers103815633hee_lers
heelless11257653heelless
heels85625533hee_l_s
heezes184211643hee_zes
heredes11313133hered_es
hondles113614523hondles
huddles123712573huddles
hurdles113613373hurdles
idles66720123__idles
keckles12318763keckles
kedges124812983_kedges
keeled114414273kee_led
keelless12236193keelless
keels94622413kee_l_s
keeves133711993kee_ves
kettles113411613kettles
kindles123614843kindles
kneeholes16113293kneeholes
kneeled12328073knee_led
kneeler11277573knee_ler
kneelers12226213knee_lers
kneels10408933knee_l_s
kneesies1245543kneesies
ladles74619543_ladles
leadless9248793leadless
ledges84918013_ledges
leeches123911933leeches
leudes75314093leud_es
measles92412753measles
meddle103312763meddle_
meddled123210033meddled
meddler11319953meddler
meddlers12318203meddlers
medley1298343_medley
medleys13115333_medleys
meeds84920273meed__s
merdes94518603merd_es
merles85322763_merles
mettles94115023mettles
middles113415303middles
muddles112914353muddles
nacelles1048393nacelles
nebulas957583nebulas
nebule848753nebule_
neckless14236433neckless
need54934153need___
needful1143863needful
needfuls1242403needfuls
needily1166323needily
neediness10227733neediness
needing93214423needing
needlefish1751183needlefish
needlessly1442903needlessly
needling10248753needling
needlings11294693needlings
needy94614693need__y
neems77316293nee__ms
neeps75617883nee__ps
negates83215843negates
neguses837933neguses
nellies73418723nellies
nemeses948663nemeses
nenes55329673n_e_nes
nerdier83110363nerdier
nerdiest92511163nerdiest
nerds65719253nerd__s
nereides938503nereides
nerolis71012783nerolis
nerols6914893nerol_s
nerves94216193n_erves
nervules1145013nervules
nesses64718323n_esses
nestle63013953nestle_
nestled8349913nestled
nestler73510453nestler
nestlers8359233nestlers
netless739863n_etless
nettle64514583nettle_
nettled8339943nettled
nettler7349503nettler
nettlers8307513nettlers
neumes83112623n_eumes
neves87021873n_e_ves
newbies12147423newbies
newels93710823newel_s
newies91014073n_ewies
newsies101310393newsies
newsless1134533newsless
nexuses1436743nexuses
nibbles114011693nibbles
nickles133713823nickles
nides65229143n_id_es
nieces84112713nie_ces
niellos736143niellos
nieves94311293nie_ves
niggles93512203niggles
nipples11319663nipples
nobbles114014523nobbles
nobles83319723n_obles
noddies93512043noddies
noddle83211363noddle_
noddled10358563noddled
nodes64633493n_od_es
nodules8269703nodules
noels56418703noe_l_s
nombles113212343nombles
noodges9317713noodges
noodle73212543noodle_
noodled9339923noodled
nopales93812523nopales
nozzles15276303nozzles
nubbles113412433nubbles
nudes64723293n_ud_es
nudges84114743n_udges
nudies75217093n_udies
numbles113814273numbles
nuncles939843nuncles
nuzzles15298123nuzzles
oodles73517183_oodles
paddles113515643paddles
padles95221123_padles
pebbles1337573pebbles
peddle103512823peddle_
peddled123410543peddled
peddler113210493peddler
peddlers12298533peddlers
pedes85327293_ped_es
pedler93614623_pedler
pedlers103013273_pedlers
peeled94119713pee_led
peeler83517383pee_ler
peelers93615593pee_lers
peels75226423pee_l_s
peeries93623023peeries
peerless1037513peerless
peeves113814873pee_ves
peewees1236803peewees
peles75738083_pe_les
peoples11312223peoples
perdues103511333perdues
pestles93217693pestles
pettles93916483pettles
piddles114314273piddles
pledges113811583pledges
poodles103013513poodles
puddles113613823puddles
raddles93615703raddles
readies83324713readies
reales64934123_reales
recedes102816063reced_es
reddle83815913reddle_
reddled102912323reddled
redes65139133_red_es
redeyes112910973redeyes
redleg839273_redleg
redlegs936823_redlegs
redoes74623773_redoes
redyes104214093_redyes
reeded84022563reed_ed
reedier83815303reedier
reediest92815423reediest
reedits8511743reedits
reedmen1038333reedmen
reeds65430903reed__s
reeled74725533ree_led
reeler63822573ree_ler
reelers73520273ree_lers
reels55333263ree_l_s
reeves94721493ree_ves
refiles104122423refiles
regales83520793regales
remedies11310553remedies
resales74724903resales
resiles74026543resiles
resoles73823653resoles
retiles74426993retiles
reviles104421353reviles
riddles93215023riddles
ruddles92813873ruddles
rundles83214713rundles
saddles95415743saddles
secedes103711983seced_es
sedges83817813_sedges
seedbed11246613seedbed
seedbeds12233703seedbeds
seeded84520463seed_ed
seeder74320773seed_er
seeders83017113seeders
seedier83513633seedier
seediest92714053seediest
seedmen1037683seedmen
seeds64330063seed__s
seeled73922093see_led
seels55632823see_l_s
seethes103613743seethes
seidels838393seidels
selles64426983_selles
seniles72618023seniles
settles73916003settles
sidles74721153_sidles
sledges94511573sledges
sneeshes1136513sneeshes
sneezes16278503snee_zes
steeples1038013steeples
steles63725663ste_les
suedes73918113sued_es
swedes102711893swed_es
teazles16308923teazles
teddies92711283teddies
teels55726373tee_l_s
teepees939263teepees
teethes103611653teethes
teles54536003_te_les
temples112610893temples
toddles93211533toddles
treadles939703treadles
trebles9311443trebles
treddles1036263treddles
tweedle1134193tweedle_
tweedled1332833tweedled
veepees1245813veepees
veeries102916893veeries
vendees114011453vendees
vendues11318623vendues
venules104011483venules
waddles124314843waddles
wedeled1237783wedeled
wedelns11325243wedelns
wedels103811033wedel_s
wedges114614583_wedges
weeded113914873weed_ed
weeder103315513weed_er
weeders113412933weeders
weedier113810623weedier
weediest122311133weediest
weeds95222213weed__s
weeklies1534913weeklies
weenies102915093weenies
weepies122811743weepies
weewees1336573weewees
weldless12285813weldless
wheedle1434833wheedle_
wheedled1633043wheedled
wheedler1543553wheedler
wheedlers1643203wheedlers
wheeples1634753wheeples
widdles123514343widdles
windles113518493windles
yodles103714333_yodles

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.563317390.8
2DLD Change Limit1340273826.95319276.1
3Display Results3823820.1402728.6
 (SQL Overall)1786913827.65623340.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.