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

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
heighten154570(None) 
heightens1644711heightens
brighten1466242brighten
eighteen1245762_eighteen
frighten1566442frighten
height134713432height__
heightened1843012heightened
heighth13366342height_h
heighths14324822heighths
heights14399442height_s
highted152710162h_ighted
lighten112811522_lighten
retighten1374772retighten
tighten11288972_tighten
weighmen1743462weighmen
weighted1635592weighted
weighter1535602weighter
alighted1347673alighted
bedighted1744583bedighted
benighted1644743benighted
bighted142810923_bighted
blighted1546863blighted
blighter1466853blighter
boughten1444193boughten
brightens1565373brightens
brighter1476663brighter
delighted1546203delighted
delighter1445583delighter
dighted132511493_dighted
eight94928053_eight__
eighteens1344883_eighteens
eighth133310603_eight_h
eighths14388293_eighths
eighties12710803_eighties
eights103618983_eight_s
eightvo1443843_eightvo
eighty133711603_eight_y
enlighten1344353enlighten
fighter143010773_fighter
flighted1646973flighted
foughten1544003foughten
freighted1755203freighted
freighter1655023freighter
frighted1657173frighted
frightens1655393frightens
hearten102411753he_arten
heathen133410893heath_en
hegumen1355463he_gumen
heigh124812543heigh___
heightening1952673heightening
heightism1843743heightism
heisted113210653hei_sted
heister103613623hei_ster
henchmen1844453henchmen
higher134610893h_igh_er
hight125327233h_ight__
highth12389153h_ight_h
highths13358003h_ighths
highting16259723h_ighting
hightop1645013h_ightop
hights133716893h_ight_s
knighted1745123knighted
lengthen1243533lengthen
lighted122913503_lighted
lightens122510003_lightens
lighter113113443_lighter
neighed12135893neigh_ed
plighted1546463plighted
plighter1476623plighter
relighted1436863relighted
resighted1436523resighted
retightens1453683retightens
righted122912143_righted
righter113212383_righter
sighted123111523_sighted
sighter113412113_sighter
slighted1357393slighted
slighter1257823slighter
tightens12297953_tightens
tighter112910693_tighter
weighed15135933weigh_ed
weigher14136343weigh_er
weighman1742483weighman
weight133914183weight__
weighters1644673weighters
weightier1643313weightier
weighting1744783weighting
weights14409553weight_s
weighty17376233weight_y

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 Filter1786911461620.1561145455.1
2DLD Change Limit146162897.54619369.5
3Display Results89890.0461934.8
 (SQL Overall)178691897.74823062.9
 
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.