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

237 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
fernless113606(None) 
farness102912202farn_ess
fearless1137872fearless
feckless17225782feckless
feeless103511102fe_eless
feetless1137382feetless
fellness1135912fellness
ferniest1132214152ferniest
ferules103112722ferule_s
fewness1335002fewn_ess
feyness1334922feyn_ess
finless102810782f_inless
fireless112810592fireless
fordless12289002fordless
forkless15267432forkless
formless13248082formless
fretless1138062fretless
furless103210142fur_less
herbless1336662herbless
hornless1137362hornless
reinless8139432reinless
termless1036232termless
veinless11136262veinless
verbless1336032verbless
airless73712043air_less
armless9369943_armless
artless73712513_artless
awnless1035923_awnless
barbless12318713barbless
barkless14318023barkless
barless94317003bar_less
beakless14297383beakless
beamless12327003beamless
beardless1234913beardless
beatless103311593beatless
bedless1039703be_dless
beefless1335493beefless
beltless10297713beltless
berryless1442293berryless
boonless10328353boonless
braless92910563_braless
careless102813633careless
carless95118493car_less
chinless1337493chinless
cordless11299963cordless
coreless103013833coreless
crewless1335413crewless
cureless10319703cureless
dearness939973dearn_ess
debtless1135653debtless
deedless10318253deedless
dewless1137473de_wless
downless1236363downless
earless74316073_earless
eeriness8311873eeriness
eggless935663_eggless
egoless836983_egoless
endless839833_endless
ernes55224813_ern_e_s
eyeless1058053_eyeless
faceless13269173faceless
fadeless12258323fadeless
fairness1136563fairn_ess
fameless13259203fameless
fangless1237663fangless
farles96025783far_le_s
fartleks1533963fartleks
fatless103212203f_atless
fatness103311293fatn_ess
feastless1235043feastless
feeblest1336913feeblest
feelers103814743fe_elers
fellers104117543fe_llers
fellest10313753fe_llest
females12310663female_s
fenceless1444163fenceless
fencers123810623fe_ncers
fences114617113fe_nce_s
fenders113717263fe_nders
fennecs12305693fe_nnecs
fennels10387903fe_nnels
fenniest113113203fenniest
ferals94216643feral__s
feres86038183fer__e_s
ferlies103216693fer_lies
fernery1335813fern_ery
fernier103110823fernie_r
ferninst11238323ferninst
fernlike1535243fernlike
ferns85220083fern___s
ferrels10248623fer_rels
ferrets103111393fer_rets
ferries103521083ferrie_s
ferrules1136163ferrule_s
ferulas103110753ferul_as
ferule93413203ferule__
feruled11318423ferule_d
fettles103912733fettle_s
fiberless1444453fiber_less
fieriness1238623fieriness
filmless1344553filmless
firmness1334743firmness
fishless1436413fishless
fitness10299393fitn_ess
flagless1235403flagless
flapless1335343flapless
flawless1434503flawless
fleckless1842893fleckless
fleshless1543993fleshless
flyless1335003f_lyless
foamless13195843foamless
fogless1138193f_ogless
foodless12338383foodless
footless113710803footless
forceless1435723forceless
forelegs1236613forelegs
fortress1136753fortress
foulness11236653foulness
freeness11710443freeness
frontless1235403frontless
fullness1135443fullness
fulness10248963fuln_ess
fumeless13236603fumeless
furlers104214223fur_lers
fuseless11237233fuseless
gainless9117403gainless
garbless11388253garbless
gearless937373gearless
gormless11235443gormless
gunless8299633_gunless
harmless1337403harmless
harness102413933harn_ess
headless12289863headless
heartless1236393heartless
heatless113011463heatless
heedless12278813heedless
heelless11257653heelless
heirless1146053heirless
helmless1334273helmless
helpless1335063helpless
henleys1334843he_nleys
hurtless11307783hurtless
hymnless1632803hymnless
innless7288293_innless
ireless72312243_ireless
juryless1832983juryless
keelless12236193keelless
keenness1234883keenness
kermess13396223ker_mess
kernels11417953kern_els
kernes104717533kern_e_s
keyless1436163ke_yless
kinless113310273_kinless
leadless9248793leadless
leafless11246573leafless
leakless12246983leakless
leanness837373leanness
legless838013le_gless
lensless835583lensless
lordless9277483lordless
lornness836493lornness
manless93012933_manless
mealless10288363mealless
meanness1037183meanness
meatless103410863meatless
merciless1344473merciless
meritless1144593meritless
merles85322763mer_le_s
moonless10278043moonless
nearness838313nearn_ess
neckless14236433neckless
needless9308333needless
nerveless1243933nerveless
netless739863ne_tless
newness1035703newn_ess
newsless1134533newsless
normless10235923normless
nounless837253nounless
oarless73913373oar_less
orbless937493_orbless
painless10108343painless
peakless14236683peakless
peerless1037513peerless
pegless1038053pe_gless
peltless10267373peltless
penniless1144013penniless
pertness10310093pertness
planless1036813planless
portless10310643portless
prebless1236823prebless
rainless8129703rainless
realness8410443realness
reckless14257973reckless
redness82012443redn_ess
restless82713163restless
runless72810423_runless
seamless10238723seamless
seatless83213003seatless
seedless9319513seedless
selfless1135013selfless
sexless1467243se_xless
sinless73014213_sinless
skinless12216973skinless
sonless72612613_sonless
spanless10247363spanless
spinless10238703spinless
sternness946093sternness
sunless73013693_sunless
tearless848713tearless
tentless8229843tentless
ternes65422903tern_e_s
textless15245793textless
thornless1243633thornless
tireless82510263tireless
townless1135653townless
treeless839283treeless
turfless1135533turfless
unless62413073__unless
veinlets11144833veinlets
ventless11249053ventless
verniers11227843verniers
vestless11258843vestless
wardless12249303wardless
warless104015103war_less
wartless11279923wartless
weariless1234763weariless
webless1237003we_bless
weedless12287963weedless
weldless12285813weldless
wellness1135793wellness
wetness10277723wetn_ess
winless103212283_winless
wireless11249633wireless
wordless12258843wordless
workless15276803workless
wornness1136363wornness
zestless17247433zestless

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 Filter1786911461620.436409841.7
2DLD Change Limit1461622377.11020557.2
3Display Results2372370.1102154.5
 (SQL Overall)1786912377.65623340.0
 
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.