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

142 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
spright13201040(None) 
sprights14167141sprights
upright13178291upright
alright1148852alright
aright103817662_aright
bright124215922_bright
fright133715242_fright
plight123513362_plight
right94430502__right
sight94629292s__ight
sleight11279022sleight
slight103416002s_light
spigot9312602sp_igot
spriest92718652spriest
sprig85617742sprig__
spriggy14374212spriggy
sprightly18133662sprightly
sprigs94814772sprig_s
sprint84526792spri_nt
sprit76736402spri__t
straight1249182straight
uplight13167362uplight
uprights14145312uprights
uptight13176032uptight
wright133713512_wright
affright1844193affright
airtight1245973airtight
alight103816863_alight
apricot111010183apricot
bedight1437483bedight
bight118728843__bight
blight124114623_blight
brights133710233_brights
copyright2053073copyright
delight12610673delight
dight104027003__dight
eight94928053__eight
esprit8312843espri__t
fight124027093__fight
flight134014813_flight
freight1447603freight
frights14339623_frights
height134713433_height
hight125327233__hight
infight1437453infight
insight1137913insight
knight1438173_knight
light94429603__light
might113827083__might
night94327853__night
outright1248743outright
plights13299313_plights
prefight1746393_prefight
priest84125423_priest
prig75924873_prig__
prigs85219703_prig_s
print74837463_pri_nt
privet113821343_privet
refight1488873refight
relight11512063relight
resight11510643resight
righto104111093__righto
rights104019333__rights
righty135011833__righty
scraigh1335673scraigh_
scraighs1443633scraighs
script105717903scri_pt
sennight1245143sennight
shipwright2251813shipwright
shrift12413543shri_ft
sigh85625903s__igh_
sighs95416743s__ighs
sights103818013s__ights
skeigh14265903skeigh_
skreigh15243703skreigh_
skreighs16203153skreighs
skylight1943993skylight
sleigh10258203sleigh_
sleighs11245673sleighs
sleights12275913sleights
slights112810723s_lights
sorgho10348713sor_gho
sought106315063s_ought
spait75631603spai__t
spigots1037793sp_igots
spilt75532223sp_i_lt
spilth11469733sp_ilth
spinet85629753sp_inet
spirant9814293spirant
spiriest102513463spiriest
spirit83519923sp_irit
spirt75032953sp_i_rt
spit65545083sp_i__t
splint85223283spli_nt
split75729013spli__t
spoilt85016593spoi_lt
spotlight1543713spotlight
sprag86418693sprag__
sprags95715823sprag_s
sprat76635973spr__at
sprent84522383spr_ent
sprier84119063spri_er
sprigged13316223sprigged
sprigger12366503sprigger
sprightful1951683sprightful
spring94526013spri_ng
springal1145973springal
springe103913983springe
springed123911323springed
springer113311753springer
springes114014033springes
springlet1257523springlet
springs104415923springs
springy13359663springy
sprints94113773sprints
sprite84421773spri_te
sprites94220333sprites
sprits85122533spri_ts
spritz174714423spri_tz
sprout8419403spr_out
sprug85313893sprug__
sprugs94010173sprug_s
spryest12247813spryest
starlight1345913starlight
stoplight1584283stoplight
straights1345813straights
strict84821043stri_ct
strigil837263strigil
stript85222193stri_pt
sunlight1245963sunlight
superlight1646033superlight
supertight1655893supertight
tight93626503__tight
tonight1138743tonight
unbright1444703unbright
unsight1137483unsight
uplights14165053uplights
uprighted1654213uprighted
uprightly18142403uprightly
weight133914183_weight
wight123725573__wight
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 Filter1786911340270.406440125.6
2DLD Change Limit1340271426.76619808.9
3Display Results1421420.0463087.0
 (SQL Overall)1786911427.21824756.3
 
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.