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

67 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
indrawn114509(None) 
undrawn1145291undrawn
drawn95614242__drawn
indraft1199562indraft
ingrain839522ingrain
ingrown1145392ingrown
misdrawn1444342misdrawn
redrawn11245952redrawn
undraw1037812undraw_
undraws1136892undraws
anuran64313243anura_n
brawn106018563__brawn
dawn85624203__d_awn
drain65222893__drain
draw85623013__draw_
drawl95516013__drawl
draws95119373__draws
drown95515823__drown
endbrain1144183endbrain
endrin7312403endr_in
engrain838353engrain
entrain7313073entrain
gnawn9517783gn__awn
hindbrain1552853hindbrain
imbrown1443883imbrown
impawn1333263i_mpawn
indaba935633ind_aba
indamin1048043indamin
indican1048243indican
indigen9319333indigen
indign8308473ind_ign
indow95011663ind_ow_
indows104210793ind_ows
indrafts1295583indrafts
indri6310793indr__i
indris7311963indr_is
indulin838773indulin
indurate9311873indurate
infra838643infra__
infract12610003infract
ingraft1199493ingraft
ingrains948983ingrains
ingrate8715123ingrate
inrun52911373in_r_un
inspan837513inspa_n
intown936153in_town
intrant7318753intrant
intron64215023intr_on
inurn53712863inur__n
inwrap11115903inwra_p
inwraps12105253inwraps
misdraw1345623misdraw_
misdraws1445753misdraws
outdrawn1245013outdrawn
prawn105312433__prawn
redraw10269853redraw_
redraws11218473redraws
thrawn12769423_thrawn
uncrown1236323uncrown
undrape1049333undrape
undrawing1436903undrawing
undrew1037913undrew_
unsawn9317463un_sawn
windrow1445853windrow_
windrows1546163windrows
wiredrawn1662343wiredrawn
withdrawn1952323withdrawn

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 Filter1786911340270.423422437.4
2DLD Change Limit134027676.65620136.3
3Display Results67670.0135153.8
 (SQL Overall)178691677.09225196.1
 
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.