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

117 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
sprights1416714(None) 
spright132010401spright_
uprights14145311uprights
brights133710232_brights
frights14339622_frights
plights13299312_plights
rights104019332__rights
sights103818012s__ights
sleights12275912sleights
slights112810722s_lights
spigots1037792sp_igots
sprightly18133662sprightly
sprigs94814772sprig__s
sprints94113772spri_nts
sprits85122532spri__ts
straights1345812straights
uplights14165052uplights
upright13178292upright_
wrights14318992_wrights
affrights1942893affrights
alights113211433_alights
alright1148853alright_
apricots1275393apricots
aright103817663_aright_
bedights1544743bedights
bights124417963__bights
blights133110213_blights
bright124215923_bright_
copyrights2152183copyrights
delights1347333delights
dights114016963__dights
eights103618983__eights
esprits938393espri__ts
fights133816553__fights
flights143310983_flights
freights1555853freights
fright133715243_fright_
heights14399443_heights
hights133716893__hights
infights1545573infights
insights1245493insights
knights1545653_knights
lights104519913__lights
mights123516253__mights
nights104117723__nights
plight123513363_plight_
priests93810863_priests
prigs85219703_prig__s
prints84320103_pri_nts
privets122910053_privets
refights1555883refights
relights1248053relights
resights1246733resights
right94430503__right_
righto104111093__righto
righty135011833__righty
scraighs1443633scraigh_s
scripts11509373scri_pts
sennights1343433sennights
shipwrights2351283shipwrights
shrifts1335963shri_fts
sighs95416743s__igh_s
sight94629293s__ight_
skreighs16203153skreigh_s
skylights2042843skylights
sleighs11245673sleigh_s
sleight11279023sleight_
slight103416003s_light_
sorghos11327603sor_ghos
spaits85017473spai__ts
spigot9312603sp_igot_
spilths12356023sp_ilths
spinets94714813sp_inets
spirants1088283spirants
spirits94112623sp_irits
spirts85317133sp_i_rts
spits74429553sp_i__ts
splints94511743spli_nts
splits85416413spli__ts
spotlights1642593spotlights
sprags95715823sprag__s
sprats85819933spr__ats
spriest92718643spriest_
sprig85617743sprig___
sprigged13316223sprigged
sprigger12366503sprigger
spriggers13325493spriggers
spriggy14374213sprig_gy
sprightful1951683sprightful
springals1245373springals
springers12309983springers
springes114014033springes
springlets1344023springlets
springs104415923spri_ngs
sprint84526793spri_nt_
sprit76736403spri__t_
sprite84421773spri__te
sprites94220333spri_tes
spritz174714423spri__tz
spritzes1946943spritzes
sprouts949983spr_outs
sprugs94010173sprug__s
starlights1443983starlights
stoplights1683113stoplights
straight1249183straight_
strigils946853strigils
sunlights1344003sunlights
tights104015853__tights
tonights1244593tonights
unsights1244623unsights
uplight13167363uplight_
uprighted1654213uprighted
uprightly18142403uprightly
uptight13176033uptight_
weights14409553_weights
wights133315783__wights
wright133713513_wright_

Search took 7 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.406440125.6
2DLD Change Limit1461621176.39022873.6
3Display Results1171170.0462543.5
 (SQL Overall)1786911176.84226116.8
 
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.