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

201 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
deadlier103686(None) 
beadier103513912bead_ier
dallier84215382d_allier
deadener1036742deadener
deader84220472dead__er
deadliest1138182deadliest
deadlift1345632deadlift
deadline10139052deadline
deadlined12125322deadlined
deadlines11138502deadlines
dealer74122142dea_l_er
deedier93011592deed_ier
drawlier12225252drawlier
earlier72612752_earlier
featlier1136452featlier
gladlier1034342gladlier
headier113212952head_ier
headliner13135392headliner
leadier83212722lead_ier
mealier93015902mea_lier
measlier1036012measlier
nearlier836802nearlier
pearlier1037322pearlier
pedalier1137602pedalier
readier83117422read_ier
vealier102712172vea_lier
weaklier1534262weaklier
beachier1538803beachier
beader94623793bead__er
beadle93314683beadl_e_
beadles103414733beadl_es
beadlike15137253beadlike
beakier134012163bea_kier
beamier113411943bea_mier
beastlier1144203beastlier
belier84423563be__lier
bendier103111413bend_ier
brawlier13267043brawlier
cleanlier1143363cleanlier
coalier93416183coa_lier
cradler102910513cradl_er
crawlier13216873crawlier
cuddlier1234013cuddlier
daddies103414943d_addies
daffier1457833d_affier
dailies84219263d_ailies
dallied93713613d_allied
dalliers93610623d_alliers
dallies84023193d_allies
dandier93714573d_andier
dandler94414273dandl_er
danglier1056753danglier
darklier1335013darklier
dashier114311183d_ashier
daubier1037103d_aubier
dawdler12356793dawdl_er
deaden83714323dead__en
deadened1137233deadened
deadeners1146283deadeners
deadeye1245163deadeye_
deadeyes1344563deadeyes
deadlifted1642393deadlifted
deadlifts1443023deadlifts
deadlight1564523deadlight
deadliness12115893deadliness
deadlock1644233deadlock
deadly113811473deadl__y
deadmen11248573dead_men
deafer104114813dea__fer
deair65817193dea__i_r
dealers84118613dea_l_ers
dealing94323233dea_ling
dearer74822803dea__rer
dearie73319813dea_rie_
dearies83526273dea_ries
decaliter1247983decaliter
deciliter1247033deciliter
decliner113710843de_cliner
decrier102713563de_crier
defaulter1343133defaulter
defier105118653de__fier
defiler113911883defil_er
deifier113013123de_ifier
dekaliter1445063dekaliter
deliver113312243de__liver
dellies83622213de_llies
delver104913493de__lver
dendrimer1343363dendrimer
denier74420693de__nier
dernier83011943de_rnier
desalter938363desalter
descrier1157623descrier
desilver12286503desilver
destrier9311823destrier
detailer9268673detail_er
dewier104013463de__wier
dialer74315433dia_l_er
dialler848813dia_ller
diddler103511513diddl_er
diddlies1137593diddlies
dimplier1336673dimplier
dodgier10388243d_odgier
doodler93310153doodl_er
dowdier12328573dowd_ier
draffier1574323draffier
draftier1285263draftier
draggier11135773draggier
drawler11338593drawl_er
dreamier11287293drea_mier
drearier9297923drea_rier
droolier936073droolier
drumlier1134523drumlier
easier64218463_ea_sier
edgier8469733_e_dgier
eelier64216463_e_elier
faddier1237783_faddier
gladier93810993glad_ier
gnarlier9255163gnarlier
godlier938893_godlier
goodlier1035793goodlier
haulier1059943_haulier
header104422543head__er
headline12129613headline
headlined14135133headlined
headliners14144333headliners
headlines13119013headlines
healer94221803hea_l_er
heartier1139103heartier
heathier1438343heathier
heavier13429423hea_vier
hedgier12367883he_dgier
idealizer1945473idea_lizer
kindlier1345763kindlier
ladler74314933_ladl_er
leachier1337253leachier
leader74824653lead__er
leafier10329833lea_fier
leakier114010993lea_kier
learier73415663lea_rier
leavier10319993lea_vier
ledgier9458503le_dgier
lordlier935363lordlier
loudlier934953loudlier
manlier92414033_manlier
marlier92614793_marlier
mealie82519813mea_lie_
mealies92821933mea_lies
meatier93214613mea_tier
meddler11319953meddl_er
needier84010623need_ier
needler8388893needl_er
nerdier83110363nerd_ier
nettlier864813nettlier
palier85023573_pa_lier
pallier94417173_pallier
peachier1548623peachier
peakier134411443pea_kier
pearler9310373pearl_er
peatier94017233pea_tier
pebblier1453263pebblier
pedaler103410693pedal_er
pedalfer1443273pedalfer
pedaliers1245183pedaliers
pedaller1136093pedaller
peddler113210493peddl_er
pedler93614623pe_dl_er
puddlier1234213puddlier
rallier73816283_rallier
reader73628293read__er
readied93316623read_ied
readies83324713read_ies
realer63528593rea_l_er
realiser82512563rea_liser
realizer172412113rea_lizer
realter73716313rea_lter
redliner93510473re_dliner
reedier83815303reed_ier
relier65826183re__lier
replier94214973re_plier
sallier73320433_sallier
scalier94316913sca_lier
sealer63928963sea_l_er
seamier93114633sea_mier
sedgier9399053se_dgier
seedier83513633seed_ier
seemlier1035193seemlier
shadier113111153shad_ier
shalier103116423sha_lier
snarlier8278183snarlier
steadier937313stead_ier
studlier935473studlier
tallier72817223_tallier
tearier73815613tea_rier
treaclier1144153treaclier
treadler936863treadl_er
vealer94016543vea_l_er
wearier103613293wea_rier
wedgier12428283we_dgier
weedier113810623weed_ier
yearlies1137603yearlies
yeastier1135393yeastier

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.423422437.4
2DLD Change Limit1461622017.67019056.3
3Display Results2012010.0802512.5
 (SQL Overall)1786912018.17321863.6
 
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.