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

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

87 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
blawn10681370(None) 
blain75421791blain
blaw97026721blaw_
blaws105620461blaws
blown105716671blown
brawn106018561brawn
lawn75925631_lawn
alan46844082ala_n
awn68035912__awn
ban58366842b_a_n
barn66444642b_arn
bawd105520842b_awd
bawl95326062b_awl
bean66443862bea_n
blab86629132bla_b
blabs95619632blabs
black134719072black
blade85923332blade
blae66134642bla_e
blaff135216482blaff
blah98625062bla_h
blahs105616512blahs
blains84516372blains
blam86131702bla_m
blame95625492blame
blams95023852blams
bland85320452bland
blank115418552blank
blare75826232blare
blase75524232blase
blast76532572blast
blat66550952bla_t
blate75933782blate
blats75132502blats
blawed124713892blawed
blawing134012752blawing
blaze165520832blaze
blazon1736762blazon
blew94722432blew_
blin67228172bl_in
blow95827192blow_
blows105423832blows
blowy134315322blowy
brain76229382brain
bran65740382bra_n
braw94829562braw_
brawl106217962brawl
brawns115614082brawns
brawny144710602brawny
braws106425192braws
brown105619532brown
bylaw13408602bylaw_
bylaws14415832bylaws
clan65633922cla_n
claw95624342claw_
claws106020832claws
clown105214732clown
dawn85624202_dawn
drawn95614242drawn
elain55324702elain
elan46734242ela_n
fawn105321952_fawn
flan76134182fla_n
flaw106326642flaw_
flaws115920342flaws
flawy145913382flawy
flown116213992flown
gnawn9517782gnawn
lain46146282_lain
law68656642_law_
lawns85215422_lawns
lawny115912012_lawny
laws76441682_laws
lown76929292_lown
mawn94424142_mawn
pawn94625302_pawn
plain74823302plain
plan65833942pla_n
prawn105312432prawn
sawn75428162_sawn
shawn116417612shawn
slain54923572slain
slaw77930712slaw_
slaws85222712slaws
spawn107811712spawn
ulan46527392ula_n
yawn106219092_yawn

Search took 2 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 Filter178691538000.0931921408.6
2DLD Change Limit53800871.51335558.5
3Display Results87870.0332636.4
 (SQL Overall)178691871.639109024.4
 
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.