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 “decrowns” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

84 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
decrowns1426506(None) 
decrown13206051decrown_
recrowns13246141recrowns
beclowns1544682beclowns
becrowds1683772becrowds
crowns115615112__crowns
dacrons103211032dacro_ns
decrowned1663652decrowned
discrowns1544662discrowns
drowns105612332d__rowns
recrown12257572recrown_
uncrowns1344362uncrowns
beckons15279143becko_ns
beclown1435423beclown_
becrawls1543623becrawls
becrowd1555173becrow_d
bedgowns1543113bedgowns
begroans1145503begroans
bicrons113410473bicro_ns
browns116415633__browns
clowns114810113__clowns
croons85418423__croons
crowds124910763__crowds
crown105620083__crown_
crows105727313__crow_s
dacron94310693dacro_n_
deacons10310393deaco_ns
decagons1235893decagons
decerns10119053dec_erns
declaws1336253declaw_s
decocts1237833dec_octs
decodes113914983dec_odes
decorous1138853decorous
decors94017773dec_o_rs
decorums1344993decorums
decos85522123dec_o__s
decoys123911283dec_o_ys
decreers11277623decreers
decrees102513123decr_ees
decrials1137133decrials
decriers11299733decriers
decries103319803decr_ies
decrowning1743593decrowning
decrying15237413decrying
decrypts1642943decrypts
decurions1246023decurions
defrocks1844113defrocks
defrosts1244833defrosts
dehorns11428363de_horns
demons94917723de_mo_ns
dendrons1047393dendro_ns
detrains9411763detrains
devons104512253de_vo_ns
discrown1445283discrown_
disowns1136733d_isowns
diurons838823diuro_ns
downs94918573d___owns
drown95515823d__rown_
drownd11478313d__rownd
drownds12346153d__rownds
embrowns1544043embrowns
escrows1235803escrow_s
frowns126011393__frowns
heroins103518013he_roins
herons94820543he_ro_ns
imbrowns1543263imbrowns
letdowns1243483letdowns
macrons113514893macro_ns
microns113814783micro_ns
necroses10310563necroses
necrosis1048883necrosis
neurons7410443neuro_ns
perrons93115483perro_ns
reckons13269653recko_ns
recoins94019243rec_oins
recons84922993rec_o_ns
recross989833recro_ss
recrowned1564853recrowned
regrown11237363regrown_
regrows11269153regrow_s
renowns10277833re_nowns
serows96016393se_row_s
teardowns1343043teardowns
uncrown1236323uncrown_

Search took 10 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.1561145455.1
2DLD Change Limit146162848.81316584.8
3Display Results84840.0302800.0
 (SQL Overall)178691848.99919856.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.