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

135 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
deadliest113818(None) 
beadiest113815532bead_iest
deadest93014882dead__est
deadlier1036862deadlie_r
deadlift1345632deadli_ft
deadlifts1443022deadlifts
deadlight1564522deadlight
deadlines11138502deadlines_
deadliness12115892deadliness
deediest102912252deed_iest
drawliest13166242drawliest
earliest82415242_earliest
featliest1238362featliest
gladliest1135372gladliest
headiest123015552head_iest
leadiest93314982lead_iest
mealiest102215972mea_liest
measliest1147172measliest
nearliest949362nearliest
pearliest1139352pearliest
readiest93719042read_iest
vealiest112513202vea_liest
weakliest1635852weakliest
beachiest1638443beachiest
beadles103414733beadl_es_
beakiest143313463bea_kiest
beamiest123212763bea_miest
beastliest1244663beastliest
bendiest112311983bend_iest
brawliest14177193brawliest
cleanliest1244353cleanliest
coaliest10316223coa_liest
crawliest14187403crawliest
cuddliest1343333cuddliest
dadaist9310103d_adai_st
daddies103414943d_addies_
daffiest1537843d_affiest
dailies84219263d_ailies_
dallies84023193d_allies_
dandiest103415033d_andiest
dangliest1137173dangliest
darkliest1435163darkliest
dashiest12311113d_ashiest
daubiest1138233d_aubiest
deadbeat1245803dead_beat
deadeyes1344563deadeyes_
deadlights1642993deadlights
deadline10139053deadli_ne
deadlined12125323deadlined
deadness1039233dead_ness
deafest112911513dea__fest
dearest83618673dea__rest
dearies83526273dea_ries_
deedless10318253deedl_ess
delist74625053de__li_st
dellies83622213de_llies_
dewiest11312343de__wiest
dialist8517763dia_li_st
diallist949553dialli_st
diddlies1137593diddlies_
dimpliest1436583dimpliest
dodgiest11308713d_odgiest
dowdiest13328953dowd_iest
draffiest1644363draffiest
draftiest1335943draftiest
draggiest12126413draggiest
dreamiest12227223drea_miest
dreariest10229123drea_riest
drooliest1036343drooliest
drumliest1235433drumliest
dualist8614053dua_li_st
easiest72318773_ea_siest
edgiest92310353_e_dgiest
eeliest73516473_e_eliest
faddiest1338113_faddiest
gladiest101710333glad_iest
gnarliest10186553gnarliest
godliest1039453_godliest
goodliest1146393goodliest
headfirst1642813headfirst
headless12289863headl_ess
headlight1744323headlight
headlines13119013headlines_
headrest122910203head_rest
heartiest12311103heartiest
heathiest1549383heathiest
heaviest143210443hea_viest
hedgiest13298133he_dgiest
idealist9310653idea_li_st
kindliest1436113kindliest
leachiest1437243leachiest
leadless9248793leadl_ess
leafiest113410883lea_fiest
leakiest123212793lea_kiest
leariest83117843lea_riest
leaviest112910813lea_viest
ledgiest10288593le_dgiest
lordliest1036103lordliest
loudliest1035773loudliest
manliest102314943_manliest
marliest102415183_marliest
mealies92821933mea_lies_
meatiest102816793mea_tiest
medalist11414213medali_st
neediest92611303need_iest
nerdiest92511163nerd_iest
nettliest945413nettliest
paliest93021603_pa_liest
palliest102814633_palliest
peachiest1638523peachiest
peakiest143512993pea_kiest
peatiest103118803pea_tiest
pebbliest1543713pebbliest
puddliest1343693puddliest
readies83324713read_ies_
realest73322433rea_l_est
realist73225383rea_li_st
reediest92815423reed_iest
scaliest101714393sca_liest
seamiest102715413sea_miest
sedgiest10259763se_dgiest
seediest92714053seed_iest
seemliest1145623seemliest
shadiest121711273shad_iest
shaliest111415053sha_liest
snarliest91810203snarliest
steadiest1038513stead_iest
studliest1036573studliest
teariest82417263tea_riest
treacliest1245383treacliest
weariest112914793wea_riest
wedgiest13307983we_dgiest
weediest122311133weed_iest
yearlies1137603yearlies_
yeastiest1237203yeastiest

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 Filter1786911486410.453394461.4
2DLD Change Limit1486411356.90621523.5
3Display Results1351350.0632142.9
 (SQL Overall)1786911357.42224075.9
 
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.