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

204 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
feckless1722578(None) 
fleckless1842891fleckless
neckless14236431neckless
reckless14257971reckless
backless162910632backless
beakless14297382beakless
checkless2044232checkless
deckles143312802deckle_s
faceless13269172faceless
fearless1137872fearless
fecklessly2282652fecklessly
feeless103511102fe_eless
feetless1137382feetless
fenceless1444162fenceless
fernless1136062fernless
ficklest17267902ficklest
flockless1843162flockless
forkless15267432forkless
freckles17126382freckle_s
frockless1843452frockless
hecklers17357122hecklers
heckles163711382heckle_s
keckles12318762keckle_s
leakless12246982leakless
luckless14265892luckless
peakless14236682peakless
rockless14297292rockless
sockless14267792sockless
suckless14288822suckless
tackless14419482tackless
wickless1736082wickless
affectless1842133affectless
barkless14318023barkless
beamless12327003beamless
beatless103311593beatless
beckets15399823beck_ets
bedless1039703be_dless
beefless1335493beefless
beltless10297713beltless
benchless1644153benchless
bucklers16349503bucklers
buckles153416093buckle_s
cacklers163710703cacklers
cackles153717203cackle_s
cheekless1873883cheekless
clickless1743983clickless
cockles153414643cockle_s
cookless14258633cookless
debtless1135653debtless
decayless1542863decayless
deciles104417723decile_s
deckels14367363deck_els
deckers144413833deck_ers
deckle1312012453deckle__
declass1038733dec_lass
deedless10318253deedless
dewless1137473de_wless
ductless11196313ductless
earless74316073_earless
echoless1345603_echoless
eggless935663_eggless
egoless836983_egoless
endless839833_endless
eyeless1058053_eyeless
fadeless12258323fadeless
fameless13259203fameless
fanciless1444603fanciless
fangless1237663fangless
fatless103212203f_atless
feastless1235043feastless
feces105625363fec__e_s
feckly18335963feckl__y
fecks145417853feck___s
feculent1346953feculent
feeblest1336913feeblest
feelers103814743fe_elers
fellers104117543fe_llers
fellest10313753fe_llest
fellness1135913fellness
females12310663female_s
ferules103112723ferule_s
fettles103912733fettle_s
fewness1335003fe_wness
feyness1334923fe_yness
fickle153912973fickle__
fickleness1943663fickleness
fickler16348423fickle_r
filmless1344553filmless
finless102810783f_inless
fireless112810593fireless
fishless1436413fishless
flagless1235403flagless
flapless1335343flapless
flawless1434503flawless
fleshless1543993fleshless
flyless1335003f_lyless
foamless13195843foamless
focusless1452263focusless
fogless1138193f_ogless
foodless12338383foodless
footless113710803footless
forceless1435723forceless
fordless12289003fordless
formless13248083formless
freckle16106643freckle__
freckled18104443freckle_d
freckliest1943383freckliest
fretless1138063fretless
fuckers163611593fuck_ers
fumeless13236603fumeless
furless103210143f_urless
fuseless11237233fuseless
gearless937373gearless
geckoes14325793geckoe_s
hacklers173710303hacklers
hackles162917063hackle_s
headless12289863headless
heatless113011463heatless
heckle153112093heckle__
heckled17318463heckle_d
heckler16278573heckle_r
heedless12278813heedless
heelless11257653heelless
heirless1146053heirless
helmless1334273helmless
helpless1335063helpless
herbless1336663herbless
hookless151238363hookless
huckles163612623huckle_s
iceless9219963_iceless
inkless11348713_inkless
jacklegs2233963jacklegs
keckle11359423keckle__
keckled13376503keckle_d
keelless12236193keelless
keyless1436163ke_yless
knockless1442443knockless
laceless10239853laceless
leadless9248793leadless
leafless11246573leafless
legless838013le_gless
lensless835583lensless
mackles154415753mackle_s
mealless10288363mealless
meatless103410863meatless
meekness1434303meekness
merciless1344473merciless
mickles153415003mickle_s
micklest16219123micklest
milkless1434773milkless
muckles153413253muckle_s
neckers134210463neck_ers
needless9308333needless
netless739863ne_tless
newsless1134533newsless
nickles133713823nickle_s
packness1636933packness
peckers153312673peck_ers
peckiest162711393peckiest
peerless1037513peerless
pegless1038053pe_gless
peltless10267373peltless
pickles153215443pickle_s
rankless12268233rankless
recess8314263rec__ess
recklessly1962923recklessly
reinless8139433reinless
restless82713163restless
riskless1235763riskless
ruckles133414603ruckle_s
seamless10238723seamless
seatless83213003seatless
seedless9319513seedless
selfless1135013selfless
sexless1467243se_xless
sickles133417543sickle_s
sickness1437833sickness
speckles16268133speckle_s
stackless1555933stackless
sucklers14379963sucklers
suckles134516743suckle_s
tacklers143010773tacklers
tackles133816523tackle_s
tactless10288463tactless
tankless12267823tankless
tearless848713tearless
tentless8229843tentless
termless1036233termless
textless15245793textless
ticklers14339303ticklers
tickles133416853tickle_s
trackless15246723trackless
tuskless1234213tuskless
veinless11136263veinless
ventless11249053ventless
verbless1336033verbless
vestless11258843vestless
viceless1337983viceless
weakness1535353weakness
webless1237003we_bless
weedless12287963weedless
weldless12285813weldless
workless15276803workless
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 Filter1786911461620.406440125.6
2DLD Change Limit1461622046.47022590.7
3Display Results2042040.0762684.2
 (SQL Overall)1786912046.95225703.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.