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

165 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
relights124805(None) 
delights1347331delights
refights1555881refights
relight11512061relight_
resights1246731resights
alights113211432_alights
bedights1544742bedights
blights133110212_blights
delight12610672delight_
eights103618982_e_ights
firelights1764012firelights
flights143310982_flights
freights1555852fre_ights
heights14399442he_ights
lights104519912__lights
penlights1544202penlights
plights13299312_plights
preflights1943322preflights
refight1488872refight_
relicts94414592reli_cts
relighted1436862relighted
relishes11311952relishes
relists73817052reli_sts
resight11510642resight_
rights104019332r__ights
sleights12275912sleights
slights112810722_slights
uplights14165052uplights
weights14409552we_ights
alight103816863_alight_
bedight1437483bedight_
beknights1942243beknights
bights124417963__bights
blight124114623_blight_
blighty16356843_blighty
brights133710233_brights
daylights1743283daylights
deadlights1642993deadlights
delicts104012253deli_cts
delighted1546203delighted
delighter1445583delighter
delighters1544363delighters
delimits1137573delimits
delists84414173deli_sts
dights114016963__dights
droplights1752603droplights
eight94928053_e_ight_
eighth133310603_e_ighth
eighths14388293_e_ighths
eighty133711603_e_ighty
elegits8149343_elegits
elicits9311233_elicits
elints65816423_eli_nts
eyesights1642203eyesights
fanlights1643923fanlights
fights133816553__fights
firefights2043313firefights
firelight1655533firelight_
flight134014813_flight_
flighty17347433_flighty
foresights1743753foresights
freight1447603fre_ight_
frights14339623_frights
gaslights1463753gaslights
greenlights1652023greenlights
headlights1842933headlights
height134713433he_ight_
heighth13366343he_ighth
heighths14324823he_ighths
heliasts1136103heliasts
hights133716893__hights
infights1545573infights
insights1245493insights
knights1545653_knights
lichts113712383__lichts
light94429603__light_
limelights1652793limelights
lowlights1643653lowlights
melilots1046553melilots
mights123516253__mights
mislights1544663mislights
neighs10387733ne_igh_s
nights104117723__nights
overlights1744853overlights
penlight1446423penlight_
plight123513363_plight_
prefight1746393prefight_
preflight1844673preflight_
prelimits1366013prelimits
realigns936253realig_ns
realists83014843reali_sts
rebirths1343083rebirths
recits83621353reci__ts
redigest1039733redigest
redigests1154683redigests
refits94017653refi__ts
reigns74811753re_ig_ns
rejigs14368093rejig__s
relegate9311243relegate
relegates10310943relegates
relents74018503rel_ents
relets64025673rel__ets
reliant7319243reliant_
relics84517903reli__cs
relict83623903reli_ct_
reliefs10439433reli_efs
reliers75519213reli_ers
relies65036423reli__es
relieves114210393relieves
relievos11374383relievos
relighting1545853relighting
religion996743religion
religions1086603religions
religiose1043633religiose
religious1076033religious
relines75331323reli_nes
relinks114510223reli_nks
reliques1736903reliques
relish93916953relish__
relished1239433relished
relist64628413reli_st_
relit55340683reli__t_
relives104619443reli_ves
relucts9369673rel_ucts
remiges103015473remig_es
remints95117293remi_nts
remits85622943remi__ts
renigs74314593renig__s
rerigs74014793rerig__s
resifts10378703resi_fts
resighted1436523resighted
resigns83910963resig_ns
resists74414923resi_sts
resits64725563resi__ts
retighten1374773retighten
retightens1453683retightens
retints74717013reti_nts
revisits1137423revisits
reweighs1583203reweigh_s
right94430503r__ight_
righto104111093r__ighto
righty135011833r__ighty
rushlights1761783rushlights
safelights17143013safelights
sennights1343433sennights
sidelights15153703sidelights
sights103818013__sights
skylights2042843skylights
sleighs11245673sleigh_s
sleight11279023sleight_
slight103416003_slight_
sprights14167143sprights
sunlights1344003sunlights
tights104015853__tights
tonights1244593tonights
twilights1642533twilights
unsights1244623unsights
uplight13167363uplight_
uprights14145313uprights
veligers1237023veligers
weighs13338873we_igh_s
weight133914183we_ight_
weighty17376233we_ighty
wights133315783__wights
wrights14318993_wrights

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.1531167915.0
2DLD Change Limit1461621657.19020328.5
3Display Results1651650.0632619.0
 (SQL Overall)1786911657.40624127.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.