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

217 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
featlier113645(None) 
beastlier1144192beastlier
deadlier1036862deadlier
earlier72612742_earlier
fattier103513462f_attier
fealties1139992fealties
feater95224052feat__er
feather133613502feat_her
featliest1238362featliest
flatliner12285382flatliner
heathier1438342heathier
mealier93015902mea_lier
measlier1036012measlier
meatier93214612meat_ier
nearlier836792nearlier
nettlier864812nettlier
pearlier1037322pearlier
peatier94017232peat_ier
vealier102712172vea_lier
weaklier1534262weaklier
atelier7311623__atelier
auntlier834903auntlier
battier93515713_battier
beachier1538803beachier
beadier103513913bea_dier
beakier134012163bea_kier
beamier113411943bea_mier
beater84729393beat__er
beetler938033beetl_er
belier84423563be__lier
brattier1047663brattier
brawlier13267043brawlier
breathier1435383breathier
cattier93317073_cattier
chattier1337513chattier
cleanlier1143363cleanlier
coalier93416183coa_lier
costlier1038523costlier
crawlier13216873crawlier
dallier84215373_dallier
dealer74122143dea_l_er
destrier9311823destrier
detailer9268673detailer
drawlier12225253drawlier
earthier1137443_earthier
earthlier1244303_earthlier
easier64218463_ea_sier
eater54639843_eat__er
eelier64216463_e_elier
fabler116115813f_abl_er
faddier1237783f_addier
faggier12309843f_aggier
faller94621233f_a_ller
falser93912413f_a_lser
falter94519053f_a_lter
fancier123412063f_ancier
farrier103514893f_arrier
father125116713f_at_her
fatlike142911193f_atlike
fatling113815683f_atling
fatter94523213f_at_ter
fatties103018203f_atties
faultier1135283f_aultier
fawnier13296363f_awnier
fearer94820183fea__rer
feaster10812983fea_ster
featherier1645803featherier
feathers143513243feat_hers
feathery17368073feat_hery
featly123711753featl__y
feature1039853feature_
featured1237683featured
features11310333features
feebler1235823feebl_er
feeler93215173fe_el_er
feistier1136193feistier
feller94419553fe__ller
fellies104119743fe_llies
feltlike1534983feltlike
fennier10339253fe_nnier
ferlie92814053fe_rlie_
ferlies103216693fe_rlies
fernier103110823fe_rnier
fertile10311733fertile_
fertilizer2245333fertilizer
fester94723513fest__er
fetcher153510393fe_tcher
fetter94120383fe_t_ter
fetterer11207813fetterer
fettle93713123fettl_e_
fettled11378933fettl_ed
fettles103912733fettl_es
fettling1266773fettling
filthier1434073filthier
flabbier1534093flabbier
flaggier13105203flaggier
flakier143910203fla_kier
flamier123112143fla_mier
flappier1544293flappier
flashier1437103flashier
flatlet10312253flatl_et
flatline11298923flatline
flatlined13275003flatlined
flatliners13254073flatliners
flatlines12268433flatlines
flatling123410013flatling
flatter103815963flat_ter
flawier13378733fla_wier
flaxier17337983fla_xier
fleshlier1542493fleshlier
flier86023403f___lier
floatier1136983float_ier
flutier103011553flut_ier
flytier13356503flyt_ier
foamier12339003foa_mier
footier104115113foot_ier
footler104011873footl_er
frailer10319943frail_er
frater94520593frat__er
freakier15246483frea_kier
frecklier1842993frecklier
frettier1156593frettier
frillier1136513frillier
frothier1435953frothier
fusilier1135423fusilier
fustier104213933fust_ier
gentler8378953gentl_er
ghastlier1342893ghastlier
gladlier1034343gladlier
gnarlier9255163gnarlier
gnattier934263gnattier
haulier1059943_haulier
headier113212953hea_dier
headliner13135393headliner
healer94221803hea_l_er
healthier1544253healthier
heartier1139093heartier
heater94828303heat__er
heather133914853heat_her
heavier13429423hea_vier
heftier1337203heft_ier
jetliner1534853je_tliner
jettier14358693je_ttier
lathier10310833_lathier
leachier1337253leachier
leadier83212723lea_dier
leafier10329833lea_fier
leakier114010993lea_kier
lealties8310793lealties
learier73415663lea_rier
leather103815783leat_her
leavier10319993lea_vier
maltier93015483_maltier
manlier92414023_manlier
marlier92614773_marlier
matier84321523_mat_ier
mealie82519813mea_lie_
mealies92821933mea_lies
metier83517693me_t_ier
motlier92010583_motlier
nattier73614623_nattier
neater64424313neat__er
nestler73510443nestl_er
nettier74211813ne_ttier
nettler7349503nettl_er
outlier72216143_outlier
palier85023563_pa_lier
pallier94417163_pallier
peachier1548623peachier
peakier134411443pea_kier
pearler9310373pearl_er
pebblier1453263pebblier
pedalier1137603pedalier
pestier94317403pest_ier
pettier94213613pe_ttier
platier93716293plat_ier
portlier1038373portlier
rallier73816273_rallier
rattier74015593_rattier
readier83117423rea_dier
realer63528593rea_l_er
realiser82512563rea_liser
realizer172412113rea_lizer
realter73716313rea_lter
realties8514853realties
relier65826183re__lier
rentier73618223rent_ier
replier94214973re_plier
retailer82911573retailer
sallier73320423_sallier
saltier74318633_saltier
scalier94316913sca_lier
scattier10267583scattier
sealer63928963sea_l_er
seamier93114633sea_mier
seater64534163seat__er
seemlier1035193seemlier
settler73410653settl_er
shalier103116423sha_lier
slatier74016813slat_ier
snarlier8278183snarlier
statelier945653statelier
sweatier1147033sweat_ier
tallier72817213_tallier
tattier74216243_tattier
tearier73815613tea_rier
tentier73815923tent_ier
testier74015643test_ier
treaclier1144153treaclier
vealer94016543vea_l_er
wealthier1543263wealthier
wearier103613283wea_rier
weather133513223weat_her
wrathier1435903wrathier
yearlies1137603yearlies
yeastier1135393yeastier
zestier163010223zest_ier

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.470380193.6
2DLD Change Limit1461622177.81018714.7
3Display Results2172170.0962260.4
 (SQL Overall)1786912178.37621333.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.