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

128 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
sleight1127902(None) 
sleigh10258201sleigh_
sleighs11245671sleighs
sleights12275911sleights
slight103416001sl_ight
alight103816862al_ight
alright1148852alright
blight124114622bl_ight
delight12610672delight
eight94928052__eight
flight134014812fl_ight
freight1447602freight
height134713432_height
light94429602_l_ight
plight123513362pl_ight
relight11512062relight
sight94629292s__ight
skeigh14265902skeigh_
sleighed1334032sleighed
sleigher1234312sleigher
slights112810722sl_ights
spright132010402spright
weight133914182_weight
alights113211433al_ights
almighty1742683almighty
aright103817663_aright
aweigh1334933aweigh_
bedight1437483bedight
bight118728843__bight
blights133110213bl_ights
blighty16356843bl_ighty
bright124215923_bright
claught1335103claught
delights1347333delights
dight104027003__dight
dreigh11246443dreigh_
eighth133310603__eighth
eights103618983__eights
eighty133711603__eighty
elegist81311973elegist
elegit71212893ele_git
eyesight1543523eyesight
fight124027093__fight
flights143310983fl_ights
flighty17347433fl_ighty
flyweight2252533flyweight
freights1555853freights
fright133715243_fright
gaslight1395343gasl_ight
heigh124812543_heigh_
heighth13366343_heighth
heights14399443_heights
hight125327233__hight
infight1437453infight
insight1137913insight
klepht1535043kle_pht
knight1438173_knight
laigh95515923_laigh_
laighs10508803_laighs
legist71315253_legist
legit61323503_le_git
length1046103_length
licht104723493_l_icht
lights104519913_l_ights
might113827083__might
mislight1447243misl_ight
neigh94912383_neigh_
neighs10387733_neighs
night94327853__night
oiltight1244543oiltight
pledget113510653pledget
plights13299313pl_ights
prefight1746393prefight
refight1488873refight
relights1248053relights
resight11510643resight
right94430503__right
safelight16124473safelight
seiche11811833s_eiche
sennight1245143sennight
sheikh16206993sheikh_
sheikhs17233993sheikhs
sheugh13295883sheugh_
sheughs14264533sheughs
sidelight14175483sidelight
sigh85625903s__igh_
sighs95416743s__ighs
sights103818013s__ights
skreigh15243703skreigh_
skreighs16203153skreighs
skylight1943993skylight
sledge85011303sledg_e
sledged103610333sledged
sledges94511573sledges
sleekit1145453sleekit
sleet55639133sle__et
sleighers1343703sleighers
sleighing1434213sleighing
slept75728103sle__pt
sleuth937233sleuth_
sleuths1034743sleuths
sliest66621963sl_iest
slighted1357393sl_ighted
slighter1257823sl_ighter
slightly1544603sl_ightly
slipt76627483sl_i_pt
slit46250103sl_i__t
slough10539233slough_
sloughs11497563sloughs
sloughy14535803sloughy
sought106315063s_ought
spigot9312603s_pigot
sprights14167143sprights
straight1249183straight
sunlight1245963sunlight
tight93626503__tight
tonight1138743tonight
unsight1137483unsight
unweight1544743unweight
uplight13167363uplight
upright13178293upright
uptight13176033uptight
weigh125412513_weigh_
weighs13338873_weighs
weights14409553_weights
weighty17376233_weighty
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.403443402.0
2DLD Change Limit1340271287.28318402.7
3Display Results1281280.0462782.6
 (SQL Overall)1786911287.73223110.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.