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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

107 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
relighted143686(None) 
delighted1546201delighted
resighted1436521resighted
alighted1347672_alighted
bedighted1744582bedighted
benighted1644742benighted
blighted1546862_blighted
delighter1445582delighter
flighted1646972_flighted
freighted1755202fre_ighted
lighted122913502__lighted
plighted1546462_plighted
preflighted2172782preflighted
relegated1139762relegated
relight11512062relight__
relights1248052relight_s
relished1239432relish_ed
relisted9312622reli_sted
retighten1374772retighten
righted122912142r__ighted
slighted1357392_slighted
unlighted1455782unlighted
uplighted1653842uplighted
weighted1635592we_ighted
beknighted2151863beknighted
bighted142810923__bighted
blighter1466853_blighter
daylighted1952193daylighted
delegated1238373delegated
delight12610673delight__
delightedly2062213delightedly
delighters1544363delighters
delights1347333delight_s
delimited1346593delimited
delisted10310563deli_sted
dighted132511493__dighted
elicited1139093_elicited
enlighten1344353enlighten
foresighted1952903foresighted
freighter1655023fre_ighter
frighted1657173_frighted
greenlighted1861263greenlighted
heighten1545703he_ighten
highted152710163__highted
knighted1745123_knighted
levigated1445643levigated
lichted13268803__lichted
ligated92414143__ligated
lighten112811523__lighten
lighter113113443__lighter
limelighted1851793limelighted
mislighted1743653mislighted
neighed12135893ne_igh_ed
obligated13186903obligated
overlighted1944213overlighted
plighter1476623_plighter
prelimited1545493prelimited
realigned1145333realig_ned
recited104319103reci__ted
redigested1354113redigested
refight1488873refight__
refights1555883refight_s
refigured1443933refigured
refitted12309413refi_tted
reigned949213re_ig_ned
reignited1145683re_ignited
rejigged1833683rejig_ged
related83327573rel__ated
relegate9311243relegate_
relegates10310943relegates
relented92614943rel_ented
relied74926233reli___ed
relieved12438513reli_eved
relighting1545853relighting
relined85321933reli__ned
relinked1337003reli_nked
relishes11311953relish_es
relived115114683reli__ved
relocated12710813relocated
relucted1138653rel_ucted
remigrated1447493remigrated
reminted113615083remi_nted
remitted113312073remi_tted
renigged1135053renig_ged
replicated1548773replicated
rerigged1136243rerig_ged
resifted12310153resi_fted
resight11510643resight__
resights1246733resight_s
resigned1038863resig_ned
resinated10413283resinated
resisted9312693resi_sted
resited85122423resi__ted
retightened1652433retightened
retightens1453683retightens
retinted94414363reti_nted
revisited1346573revisited
reweighed1742903reweigh_ed
righter113212383r__ighter
sighted123111523__sighted
skylighted2251803skylighted
sleighed1334033sleigh_ed
slighter1257823_slighter
unsighted1455433unsighted
uprighted1654213uprighted
weighed15135933we_igh_ed
weighter1535603we_ighter

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.423422437.4
2DLD Change Limit1486411077.39020113.8
3Display Results1071070.0462326.1
 (SQL Overall)1786911077.85922737.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.