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

80 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
redheaded154508(None) 
beheaded1536372be_headed
deadheaded1742832deadheaded
redhead1257052redhea__d
redheads1336172redhead_s
redreamed1345022redreamed
reheated122415002re_heated
repleaded1336292repleaded
rethreaded1543272rethreaded
retreaded1137052retreaded
airheaded1443953airheaded
bareheaded1763953bare_headed
beheader1436043be_header
besteaded1345043besteaded
bigheaded1743923bigheaded
coheaded1536603_coheaded
deleaded1148333de_leaded
dreaded103612023__dreaded
eggheaded1642563eggheaded
fatheaded1744273fatheaded
hardheaded1953853hardheaded
headed114020473___headed
hotheaded1744853hotheaded
pigheaded1743813pigheaded
pinheaded1644223pinheaded
preheated1539813pre_heated
reblended1355203reblended
receded112713043re_ce_ded
rechecked2143973rechecked
rechewed1735633reche_wed
recleaned1236583recleaned
recreated12412533recreated
redamaged1443343redamaged
redated93120923red__ated
redded94019553red___ded
reddened1136423redde_ned
redecided1455123redecided
redeemed1235593red_eemed
redefeated1544883redefeated
redefied1368223red_efied
redemanded1543233redemanded
redenied10511283red_enied
redialed10310793red_ialed
redivided1544253redivided
rednecked1743163rednecked
redounded1235263redounded
redressed1137773redressed
reeded84022563re__e_ded
regeared1039433re_geared
regraded113410763re_graded
reheard11309023re_hea_rd
rehearsed13305913re_hearsed
reheater113413033re_heater
reheeled1236773re_heeled
rehemmed1634153re_hemmed
reinvaded1444073reinvaded
released9310243re_leased
reloaded1059103re_loaded
remended123010393re_mended
renegaded1244603renegaded
repealed113211873re_pealed
repeated113117443re_peated
rephrased1555283rephrased
repleader1245393repleader
resealed92713963re_sealed
reseated93220263re_seated
reseeded1038093re_seeded
reshaped1437203resh_aped
reshaved1536873resh_aved
respaded1238133re_spaded
reteamed1138013re_teamed
retreated10312623retreated
revealed123211213re_vealed
reweaved1535953re_weaved
rewedded1434513re_wedded
rewelded1335893re_welded
roundheaded1752163roundheaded
sapheaded1644183sapheaded
soreheaded1544303sore_headed
towheaded1742823towheaded

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 Filter1786911486410.406440125.6
2DLD Change Limit148641806.81321817.3
3Display Results80800.0461739.1
 (SQL Overall)178691807.26524596.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.