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

110 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
necrosed113721(None) 
necrose939721necrose_
necroses10310561necroses
enclosed1198252enclosed
necropsied1542952necropsied
necrosis1048882necrosis
neuroses8310152neuroses
recrossed1246512recrossed
acerose9310893acerose_
beckoned1735783beckoned
becrimed1565513becrimed
becrowd1555173becro_wd
becrowded1842923becrowded
becrusted1443943becrusted
becursed1335583becursed
berobed1238233be_robed
closed95317963__closed
crossed105313893__crossed
crowed124717303__crowed
deceased1247713deceased
decoded123212383dec_oded
decoyed14358333dec_oyed
decreased1345453decreased
decreed112710253decr_eed
decried112612853decr_ied
decrowned1663653decrowned
defrosted1444253defrosted
deposed113412023de_posed
echoed125211153_echo_ed
encased103512313enc_ased
enchased1437383enchased
enclose999993enclose_
encloser10107183encloser
encloses10911053encloses
encoded1139033enc_oded
encored10412103enc_ored
encrusted12125003encrusted
endorsed1057193endorsed
engrossed1144313engrossed
enrobed10279253_enrobed
erased74816753_e_rased
eroded84313583_e_roded
erose55727273_e_rose_
eroses65327053_e_roses
escrowed1434653escrowed
exposed1737443_exposed
hearsed113811403hear_sed
hectored1436873hectored
inclosed1197613inclosed
incrossed1244743incrossed
leprose938543leprose_
nacred95212493nacr__ed
narcose95910383narcose_
narcoses103910543narcoses
narrowed1235203narrowed
neared75119803near__ed
necked134715063nec__ked
necropsies1444743necropsies
necropsy1542953necropsy
necrosing1247693necrosing
necrotic12310043necrotic
necrotized2245083necrotized
negroid9108893negro_id
neoned7311483ne__oned
nephroses1446303nephroses
nerved104111683ne_r_ved
neuroid81110303neuro_id
neurone739433neurone_
neurones839673neurones
neurosal845833neurosal
neurosis848843neurosis
noosed75018013n__oosed
nosed65524553n___osed
nursed74514663n_ur_sed
perused103112193pe_rused
prosed94921093__prosed
rearoused1047093rearoused
recessed1139713recessed
rechose121312043rechose_
rechosen13127033rechosen
reckoned1546953reckoned
recoded113115033rec_oded
recooked15268243recooked
recorded122511063recorded
recorked15239853recorked
recrated112918603recrated
recross989833recros_s
recrosses1138373recrosses
recrowned1564853recrowned
recused104714423rec_used
reposed103616273re_posed
reprised112012203reprised
reprobed13228743reprobed
reproved14199473reproved
rerose63320843re_rose_
rosed65930343___rosed
secreted1138633secreted
sectored1138063sectored
sucrose939303sucrose_
sucroses1039933sucroses
unclosed111010503unclosed
uncrossed1236313uncrossed
unenclosed1342653unenclosed
unerased9312773une_rased
unexposed1943433unexposed
vectored1435623vectored
versed104515513ve_r_sed
xeroses143612823xe_roses
xeroxed14244523xe_roxed
zeroed16409413ze_ro_ed

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.423422437.4
2DLD Change Limit1461621106.64022012.3
3Display Results1101100.0462391.3
 (SQL Overall)1786911107.10925135.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.