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

341 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
ferniest113221415(None) 
fenniest113113201fenniest
ferninst11238321ferninst
aeriest73924052aer_iest
barniest104815052barniest
corniest102117302corniest
eeriest73620672eer_iest
fawniest14287442fawniest
ferlies103216692ferlies_
fernier103110822fernie_r
fernless1136062fernless
ferries103521082ferries_
fieriest112112242fier_iest
finniest113011402finniest
firriest112310432firriest
forkiest153812302forkiest
funniest113010732funniest
furriest112910792furriest
furziest20267782furziest
germiest11249922germiest
herbiest1339992herbiest
horniest112814042horniest
jerkiest19328112jerkiest
merriest10311482merriest
nerdiest92511162nerdiest
nerviest11188832nerviest
perkiest143313242perkiest
porniest103214312porniest
teeniest82112412teeniest
veiniest1139382veiniest
veriest103719132ver_iest
weeniest112411212weeniest
wenniest11259592wenniest
aeries64737783aer_ies_
airiest74221013air_iest
artiest73121993_artiest
barkiest144115153barkiest
barmiest125212783barmiest
beadiest113815533beadiest
beakiest143313463beakiest
beamiest123212763beamiest
beanies93821093beanies_
beefiest13269013beefiest
beeriest104013403beeriest
bendiest112311983bendiest
bennies93917313bennies_
berries94423553berries_
boniest93318993_boniest
bonniest10310773bonniest
briniest102812333briniest
burliest103113063burliest
burnies94017823burnies_
burriest102911213burriest
byrnies12378573byrnies_
canniest10313363canniest
carnies94123963carnies_
chertiest1438793chertiest
corkiest143114793corkiest
crepiest12310383crepiest
curdiest112511393curdiest
curliest102713123curliest
curviest13309673curviest
darndest1067223darndest
deediest102912253deediest
denies74729643de_nies_
densest83112473de_nsest
derbies103016053derbies_
dernier83011943dernie_r
derries83124623derries_
dewiest11312343de_wiest
dirtiest93014203dirtiest
dorkiest133111253dorkiest
downiest122710603downiest
driest74722753_dr_iest
durndest1065763durndest
earliest82415243earliest
earnest7318733earn_est
easiest72318773_easiest
edgiest92310353_edgiest
eeliest73516473_eeliest
eeriness8311873eeriness
elmiest9310743_elmiest
ernes55224813_ern_es_
faddiest1338113faddiest
faeries104118993faer_ies_
faggiest132910183faggiest
fainest10417703fain_est
faintest1139073faintest
fanciest133612713fanciest
fannies103415643fannies_
farcies125317883farcies_
farness102912203farn_ess
farthest1499863farthest
fattiest113514313fattiest
featest102715113fe_atest
featliest1238363featliest
feeblest1336913feeblest
feist86230073fe__i_st
feistiest1237073feistiest
felines104718073felines_
fellest10313753fe_llest
fellies104119743fellies_
felonies11310993felonies_
feminist131911333feminist
fences114617113fe_nces_
fennier10339253fennie_r
feres86038183fer__es_
ferias95020393fer_ias_
ferine96422583ferine__
ferities111416723ferities_
ferlie92814053ferlie__
ferment12315573fer_ment
fermis114313503fermi_s_
ferneries1239053ferneries_
fernery1335813fern_ery
ferns85220083fern__s_
ferret93021173fer_re_t
ferrets103111393fer_rets
ferried113411533ferrie_d
ferrites112312833ferrites_
ferules103112723ferules_
fervent13310063fer_vent
feudist1137573feudi_st
fewest12311663fe__west
fewness1335003fewn_ess
feyest12311403fe__yest
feyness1334923feyn_ess
fiercest13216143fier_cest
fieriness1238633fieriness
filmiest1338553filmiest
finest94321733f_in_est
firmest1239273fir_mest
fishiest14310453fishiest
fizziest19226073fizziest
flakiest153210553flakiest
flamiest133111983flamiest
flawiest14298583flawiest
flaxiest18298193flaxiest
fledgiest1444183fledgiest
fleeciest1434873fleeciest
fleshiest1576233fleshiest
fliest94718433f__liest
flintiest1248443flintiest
flirtiest1236193flirtiest
flukiest15248063flukiest
flutiest112610883flutiest
foamiest13289853foamiest
foggiest13249653foggiest
folkiest15319503folkiest
fondest11312403f_ondest
footiest113514913footiest
forest94926743for__est
fornent10312933forn_ent
fornices1369103fornices_
forties104323863forties_
foxiest174310493f_oxiest
foziest194110943f_oziest
frailest1139493f_railest
frankest1536963frankest
freakiest16206693freakiest
freest95318283f_r_eest
frenzies2037713frenzies_
freshest143010583freshest
frettiest1267073frettiest
fries85535603f_r_ies_
fringiest1347613fringiest
fubsiest13258413fubsiest
fuggiest13228813fuggiest
fumiest12312193f_umiest
funest94316863f_un_est
funfest13348083f_unfest
funkiest152810973funkiest
funnest102912003f_unnest
funnies104113603funnies_
furies95126373fur_ies_
furnish1337383furni_sh
furthest1496863furthest
fussiest112910493fussiest
fustiest113014573fustiest
fuzziest19235793fuzziest
geekiest13257873geekiest
gemmiest13227633gemmiest
genies75324943ge_nies_
ginniest92610513ginniest
girliest93010403girliest
gooniest93213003gooniest
goriest82218743gor_iest
gorsiest92511133gorsiest
greeniest1039033greeniest
hardiest123416343hardiest
headiest123015553headiest
heartiest12311103heartiest
heaviest143210443heaviest
hedgiest13298133hedgiest
heftiest1439183heftiest
heinies102514543heinies_
hempiest1539043hempiest
henries102718283henries_
hernias10310773hernias_
herries104025083herries_
hornist102314823horni_st
horsiest112513263horsiest
jennies143511623jennies_
jerkies183411583jerkies_
jerries143817513jerries_
jettiest15359593jettiest
keenest11410963keen_est
kernes104717533kern_es_
kernites1269113kernites_
kerries113317913kerries_
lardiest93813893lardiest
larkiest123713323larkiest
leadiest93314993leadiest
leafiest113410893leafiest
leakiest123212803leakiest
leanest7415863lean_est
leariest83117853leariest
leaviest112910823leaviest
ledgiest10288593ledgiest
leeriest83112883leeriest
leggiest10308233leggiest
lenient7313843le_nient
liniest73321153_liniest
looniest83313253looniest
luniest73516993_luniest
marliest102415193marliest
mealiest102215973mealiest
meanest9315703mean_est
meanies93620743meanies_
meatiest102816793meatiest
meinies92516073meinies_
mercies113817563mercies_
merest84725113mer__est
meshiest132911033meshiest
messiest103112423messiest
miriest93619823mir_iest
mirkiest142910253mirkiest
mooniest103014173mooniest
murkiest143210273murkiest
nearliest949363nearliest
neediest92611303neediest
nettiest83112433nettiest
newsiest11107483newsiest
oneriest8313443oner_iest
orbiest9312413_orbiest
peakiest143513003peakiest
pearliest1139363pearliest
peatiest103118813peatiest
peckiest162711393peckiest
pennies94218813pennies_
peonies93620153peonies_
peppiest11278573peppiest
perries93226603perries_
persist9315853persi_st
pertest9317043per_test
peskiest142610163peskiest
pestiest103018413pestiest
pettiest103113963pettiest
phoniest132811543phoniest
piniest93121133_piniest
porkiest143513713porkiest
priest84125423_pr_iest
puniest92918093_puniest
punniest102511583punniest
pursiest102812123pursiest
purtiest102414113purtiest
rainiest81214923rainiest
readiest93719043readiest
reediest92815423reediest
reefiest112811483reefiest
reekiest122711313reekiest
reinvest1138203reinvest
renest64529713re_n_est
runniest82911203runniest
sarkiest123615073sarkiest
seamiest102715423seamiest
sedgiest10259763sedgiest
seediest92714053seediest
seepiest102412633seepiest
serenest82717623serenest
serest64831613ser__est
series64540973ser_ies_
serines74229543serines_
serries73925353serries_
sexiest142112223se_xiest
sheeniest12158363sheeniest
shiniest113212503shiniest
sorriest8413883sorriest
spiniest102813233spiniest
spriest92718653spr_iest
sternest8314433stern_est
stoniest8413543stoniest
sunniest82712913sunniest
surfiest112414433surfiest
surliest82416913surliest
tardiest93515243tardiest
tarriest83215003tarriest
tartiest82718313tartiest
tawniest11279343tawniest
teariest82417263teariest
techiest1359833techiest
teensiest945833teensiest
tennies73017973tennies_
tennist72813113tenni_st
tensest72713313te_nsest
tentiest82115613tentiest
ternes65422903tern_es_
terries73425633terries_
tersest71713993ter_sest
testiest82715223testiest
thorniest1236483thorniest
tiniest73020123_tiniest
tinniest82911463tinniest
toniest73218903_toniest
trendiest1038423trendiest
turfiest112410133turfiest
twiniest1147153twiniest
vealiest112513203vealiest
verist93823893ver_i_st
vernier102711273vernie_r
verniers11227843verniers
vernixes1836053vernixes_
viniest103216613_viniest
waniest103819113_waniest
wariest105122503war_iest
wartiest113614643wartiest
weariest112914793weariest
webbiest1535353webbiest
wedgiest13307983wedgiest
weediest122311133weediest
weenies102915093weenies_
weensiest1244753weensiest
weepiest13219473weepiest
whiniest14298753whiniest
winiest103419693_winiest
wiriest103816853wir_iest
wordiest122311543wordiest
wormiest13249543wormiest
wriest94419713_wr_iest
zaniest163214773_zaniest
zestiest173011103zestiest

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.406440125.6
2DLD Change Limit1461623416.70321805.5
3Display Results3413410.1402435.7
 (SQL Overall)1786913417.24924650.4
 
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.