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

137 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
blighty1635684(None) 
blight124114621blight_
blights133110211blights
flighty17347431flighty
alight103816862alight_
alights113211432alights
almighty1742682almighty
bight118728842b_ight_
bights124417962b_ights
blighted1546862blighted
blighter1466852blighter
bright124215922bright_
brightly1764552brightly
brights133710232brights
eighty133711602_eighty
flight134014812flight_
flights143310982flights
light94429602_light_
lightly14369022_lightly
lights104519912_lights
mighty154310212_mighty
nighty135611272_nighty
plight123513362plight_
plights13299312plights
righty135011832_righty
slight103416002slight_
slightly1544602slightly
slights112810722slights
weighty17376232weighty
alighted1347673alighted
alright1148853alright_
aright103817663aright_
bedight1437483bedight_
bedights1544743bedights
beigy111110583beig__y
bigamy1436343b_igamy
biggety1434433biggety
biggity1435013biggity
biggy124413133b_ig_gy
bighted142810923b_ighted
bigly114814753b_ig_ly
bigot84828323b_igot_
bigotry1344523b_igotry
bigots95015133b_igots
bilgy114713713bilg__y
bitty106119173b_i_tty
blasty115611053bl_asty
blighters1555743blighters
blighties1546223blighties
blighting1635733blighting
blimey13468453bli_mey
blimy125212823bli__my
blindly1335743blindly
blintz1788843bli_ntz
blite76225353bli__te
blithe115810863blith_e
blithely16104033blithely
blither124812173blither
blitz165318133bli__tz
blotty11178343bl_otty
bought125115633bought_
brighten1466243brighten
brighter1476663brighter
delight12610673delight_
delights1347333delights
dight104027003_dight_
dights114016963_dights
doughty15436023doughty
eight94928053_eight_
eighth133310603_eighth
eights103618983_eights
fight124027093_fight_
fights133816553_fights
flighted1646973flighted
flightily1943353flightily
flinty126112493fli_nty
flirty12499143fli_rty
fright133715243fright_
frights14339623frights
glinty106910693gli_nty
haughty17334643haughty
height134713433height_
heighth13366343heighth
heights14399443heights
highly1636823_highly
hight125327233_hight_
highth12389153_highth
hights133716893_hights
knight1438173knight_
knightly1953013knightly
knights1545653knights
licht104723493_licht_
lichtly15255523_lichtly
lichts113712383_lichts
ligate72519253_ligate
lighted122913503_lighted
lighten112811523_lighten
lighter113113443_lighter
linty87126563_li_nty
might113827083_might_
mights123516253_mights
naughty14445623naughty
night94327853_night_
nightly14449033_nightly
nights104117723_nights
obligate11198303obligate
obligati11184833obligati
obligato11194983obligato
paughty16294323paughty
pigsty1235933_pigsty
plighted1546463plighted
plighter1476623plighter
relight11512063relight_
relights1248053relights
right94430503_right_
rightly14389043_rightly
righto104111093_righto
rights104019333_rights
sight94629293_sight_
sightly14408273_sightly
sights103818013_sights
sleight11279023sleight_
sleights12275913sleights
slighted1357393slighted
slighter1257823slighter
slitty9329163sli_tty
tight93626503_tight_
tightly14327613_tightly
tights104015853_tights
uplight13167363uplight_
uplights14165053uplights
weight133914183weight_
weights14409553weights
wight123725573_wight_
wights133315783_wights
wright133713513wright_
wrights14318993wrights

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 Limit1340271377.14318763.4
3Display Results1371370.0462978.3
 (SQL Overall)1786911377.59523527.5
 
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.