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

121 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
defleaed134495(None) 
befleaed1454661befleaed
deflexed2043881deflexed
defeated132812162def_eated
deflated133412302deflated
deflea1037442deflea__
defleas1147222deflea_s
deflected1635982deflected
defueled1374512defueled
delead84112342de_lea_d
deleaded1148332de_leaded
deleaved1346572de_leaved
deleted93314912de_leted
depleted12258722depleted
reflexed1975252reflexed
beflea1147123beflea__
befleas1236973beflea_s
beflecked2142653beflecked
beleaped1336103be_leaped
deadened1137233deadened
deafened1335853deafened
dealated103213603dealated
debeaked1634613de_beaked
debeard1137353de_beard
deceased1247713de_ceased
declared1248743declared
declawed1545923declawed
declined123910883declined
decreased1345453decreased
decreed112710253decre_ed
deeded94615543de__eded
deemed104713063de__emed
deepened1235663deepened
defaced142910973def_aced
defalcated1744183defalcated
defamed14309833def_amed
defanged1435433defanged
defatted1335673defatted
defeat103817163def_ea_t
defeater122611663def_eater
defeats113511233def_eats
defecated1637493defecated
defected15289973defected
defenced1537203defenced
defend113910493def_e_nd
defended1437223defended
defensed1336223defensed
deferred13106363deferred
defied115016383def__ied
defilade13124433defilade
defiladed15143473defiladed
defiled124013103def_iled
defined123813823def_ined
deflate113613943defl_ate
deflater123211603deflater
deflates123013943deflates
defleaing1444743defleaing
deflect13399973defle_ct
deflects14336733deflects
deflower15126073deflower
deflowered1842513deflowered
defoamed15356243defoamed
defogged1533783defogged
defoliated1545833defoliated
deforced15247373deforced
deformed15248263deformed
defraud1243913def_raud
defrayed1635403defrayed
defuelled1443133defuelled
defunded1435163defunded
defused125211093def_used
defuzed21447043def_uzed
deglazed2034953deglazed
degreased1244713degreased
degreed10258883degre_ed
delated93722873de_lated
delayed123310763de_layed
deleads9379703de_leads
deleave1147723de_leave
deleaves1248063de_leaves
deled75326543de_l__ed
delegated1238373de_legated
delete73620703de_lete_
deletes83117933de_letes
delimed11310723de_limed
deluded10158763de_luded
deluged10167413de_luged
delved114112753de_l_ved
demeaned1237283de_meaned
deplaned1238663deplaned
deplete103010423deplete_
depleter11298863depleter
depletes112810643depletes
deplored1237233deplored
deployed1535913deployed
deplumed1434083deplumed
desexed1636183de_sexed
develed123611933de_veled
differed1635523differed
duplexed1943143duplexed
flexed17419093__flexed
fleyed13408813__fleyed
inflexed1944023inflexed
leafleted1342893leafleted
pelleted1138203pelleted
recleaned1236583recleaned
refeed104717623ref_e_ed
refelled122810173refelled
reflated123514293reflated
reflected1547983reflected
reflexes1865933reflexes
refloated1347013refloated
reflowed15126903reflowed
refluxed1954353refluxed
refueled1286573refueled
released9310243re_leased
replead10399013replea_d
repleaded1336293repleaded
telexed1536323te_lexed
telfered1234883telfered
unflexed1935263unflexed

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 Limit1461621217.15620425.1
3Display Results1211210.0502420.0
 (SQL Overall)1786911217.64223382.8
 
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.