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

89 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
drawn9561424(None) 
brawn106018561brawn
dawn85624201d_awn
drain65222891drain
draw85623011draw_
drawl95516011drawl
draws95119371draws
drown95515821drown
prawn105312431prawn
awn68035912__awn
blawn106813702blawn
brain76229382brain
bran65740382bra_n
braw94829562braw_
brawl106217962brawl
brawns115614082brawns
brawny144710602brawny
braws106425192braws
brown105619532brown
craw97725262craw_
crawl104916712crawl
craws105723122craws
crown105620082crown
damn75724322d_amn
dan46859672d_a_n
darn56434622d_arn
daw77148362d_aw_
dawen95413722d_awen
dawk126117282d_awk
dawns95916592d_awns
daws86638242d_aws
dawt85435942d_awt
dean56039482dea_n
dewan95718042dewan
diwan95712552diwan
down86427492d_own
drab76226452dra_b
drabs85119672drabs
draff125615662draff
draft95526682draft
drag64825052dra_g
dragon838842dragon
drags75521112drags
drail65020972drail
drains73719402drains
drake104918302drake
dram75832002dra_m
drama85117422drama
drams86025832drams
drank104816202drank
drape85319632drape
drat56247832dra_t
drats66628372drats
drave95219272drave
drawee104413822drawee
drawer104711362drawer
drawing123812052drawing
drawls105511392drawls
drawly134910722drawly
dray85428092dra_y
drays95819772drays
drew86221672drew_
drownd11478312drownd
drowns105612332drowns
fawn105321952_fawn
frown115415972frown
gnawn9517782gnawn
grain65126252grain
gran56335012gra_n
grown95317352grown
indrawn1145092indrawn
lawn75925632_lawn
mawn94424142_mawn
pawn94625302_pawn
prawns11509022prawns
rain46251732_rain
ran38266622_ra_n
raw67252252_raw_
rawin85521472_rawin
raws75238212_raws
redrawn11245952redrawn
sawn75428162_sawn
shawn116417612shawn
spawn107811712spawn
thrawn12769422thrawn
train56529112train
trawl84915872trawl
undrawn1145292undrawn
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.313570897.8
2DLD Change Limit53800891.39338621.7
3Display Results89890.0136846.2
 (SQL Overall)178691891.719103950.6
 
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.