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

161 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
delight1261067(None) 
delights1347331delights
relight11512061relight
alight103816862_alight
bedight1437482bedight
blight124114622_blight
daylight1644512daylight
deadlight1564522deadlight
delict94320332deli_ct
delighted1546202delighted
delighter1445582delighter
delimit10311732delimit
delish105215612delish_
delist74625052deli_st
dight104027002d__ight
eight94928052_e_ight
flight134014812_flight
height134713432he_ight
light94429602__light
penlight1446422penlight
plight123513362_plight
refight1488872refight
relights1248052relights
resight11510642resight
sidelight14175482sidelight
sleight11279022sleight
slight103416002_slight
uplight13167362uplight
weight133914182we_ight
alights113211433_alights
alright1148853alright
aright103817663_aright
bedights1544743bedights
beknight1843563beknight
bight118728843__bight
blights133110213_blights
blighty16356843_blighty
bright124215923_bright
daylights1743283daylights
deadlights1642993deadlights
debit85727853debi__t
defiant11311923defiant
deficit1339673deficit
deign74312803de_ig_n
deigns8389983de_igns
deist64633593de_i_st
delegate10410463delegate
delft95623323del__ft
deli55631293deli___
delicate11315493delicate
delicts104012253delicts
delighters1544363delighters
delightful1851423delightful
delighting1644993delighting
delime9314043deli_me
delimed11310723delimed
delimes10314193delimes
delimits1137573delimits
deliria868303deliria
delis64928543deli__s
delists84414173delists
deliver113312243deliver
delt57855273del___t
deluge8189403delug_e
deluged10167413deluged
deluges9169263deluges
demigod1254193demigod
demit84832303demi__t
depict113514793depi_ct
design8408933desig_n
designs9328313designs
desist74818813desi_st
deviant11311313deviant
dewiest11312343dewiest
dights114016963d__ights
digit73825273d__igit
diligent1048033diligent
dogfight1742993dogfight
dought114915523d_ought
downlight1744003downlight
draught12266983draught
dreigh11246443dreigh_
droplight1643803droplight
drought12258883drought
duelist8511413dueli_st
eeliest73516473eeliest
eighth133310603_e_ighth
eights103618983_e_ights
eighty133711603_e_ighty
elegit71212893_elegit
elicit8417203_elicit
elint55436473_eli_nt
eyesight1543523eyesight
fanlight1545843fanlight
fight124027093__fight
firelight1655533firelight
flights143310983_flights
flighty17347433_flighty
freight1447603freight
fright133715243_fright
gaslight1395343gaslight
headlight1744323headlight
heigh124812543he_igh_
heighth13366343he_ighth
heights14399443he_ights
heliast10312073heliast
hight125327233__hight
infight1437453infight
inflight1545893inflight
insight1137913insight
knight1438173_knight
licht104723493__licht
lights104519913__lights
limelight1544243limelight
lowlight1554943lowlight
melilot9311083melilot
might113827083__might
mislight1447243mislight
neigh94912383ne_igh_
neighs10387733ne_ighs
night94327853__night
oiltight1244543oiltight
overlight1647793overlight
penlights1544203penlights
plights13299313_plights
prefight1746393prefight
preflight1844673preflight
refights1555883refights
reliant7319243reliant
relict83623903reli_ct
relighted1436863relighted
relish93916953relish_
relist64628413reli_st
relit55340683reli__t
resights1246733resights
right94430503__right
safelight16124473safelight
sennight1245143sennight
sidelights15153703sidelights
sight94629293__sight
skylight1943993skylight
sleigh10258203sleigh_
sleighs11245673sleighs
sleights12275913sleights
slights112810723_slights
spright132010403spright
sunlight1245963sunlight
tight93626503__tight
tonight1138743tonight
twilight1543903twilight
unsight1137483unsight
uplights14165053uplights
upright13178293upright
uptight13176033uptight
veliger1137313veliger
weigh125412513we_igh_
weighs13338873we_ighs
weights14409553we_ights
weighty17376233we_ighty
wight123725573__wight
wright133713513_wright

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.406440125.6
2DLD Change Limit1340271617.04619021.7
3Display Results1611610.0632555.6
 (SQL Overall)1786911617.51523777.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.