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

53 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
discrown144528(None) 
discrowns1544661discrowns
decrown13206052d_ecrown
discrowned1744022discrowned
disown1036952dis__own
misgrown1443982misgrown
bestrown1345203bestrown
bicron103710773bi_cro_n
cistron9299883cistro_n
crown105620083___crown
dacron94310693d_acro_n
decrowns14265063d_ecrowns
diatron839283diatro_n
disavow1443603disavow_
disavows1544043disavows
discern1038493disc_ern
disclose1148743disclose
disco85616073disc_o__
discoed11312483disc_oed
discoid11311243disc_oid
discoing12511453disc_oing
discord1139993disc_ord
discords1238593discords
discos94915213disc_o_s
discount11811313disc_ount
discreet11413183discreet
discrete11410283discrete
discrowning1843803discrowning
disfrock1843303disfrock
disjoin1547643dis_join
disowns1136733dis__owns
disproof1446253disproof
disprove14138193disprove
disproven15146473disproven
disrobe1038993dis_robe
disroot8413563dis_root
distrain9412243distrain
diuron738573di_uro_n
drown95515823d___rown
escrow1135913_escrow_
escrows1235803_escrows
imbrown1443883_imbrown
ingrown1145393_ingrown
micron103714283mi_cro_n
miscoin11311433misc_oin
misdrawn1444343misdrawn
misgrow1344433misgrow_
misgrows1444963misgrows
misknown1742533misknown
misthrown1793133misthrown
recrown12257573_recrown
strown96812093__strown
uncrown1236323_uncrown

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.860207780.2
2DLD Change Limit146162538.33017546.5
3Display Results53530.0134076.9
 (SQL Overall)178691539.20319416.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.