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

239 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
blights13311021(None) 
alights113211431alights
bights124417961b_ights
blight124114621blight_
blighty16356841blighty
brights133710231brights
flights143310981flights
lights104519911_lights
plights13299311plights
slights112810721slights
alight103816862alight_
bedights1544742bedights
bight118728842b_ight_
bigots95015132b_igots
blighted1546862blighted
blighter1466852blighter
blighters1555742blighters
blighties1546222blighties
bright124215922bright_
delights1347332delights
dights114016962_dights
eights103618982_eights
fights133816552_fights
flight134014812flight_
flighty17347432flighty
frights14339622frights
heights14399442heights
hights133716892_hights
knights1545652knights
lichts113712382_lichts
light94429602_light_
mights123516252_mights
nights104117722_nights
plight123513362plight_
relights1248052relights
rights104019332_rights
sights103818012_sights
sleights12275912sleights
slight103416002slight_
tights104015852_tights
uplights14165052uplights
weights14409552weights
wights133315782_wights
wrights14318992wrights
alighted1347673alighted
aligns75312953alig_ns
almighty1742683almighty
alright1148853alright_
aright103817663aright_
aughts104710243_aughts
backlights2253993backlights
bahts105617803b__ahts
baits76630583bai__ts
bedight1437483bedight_
begets96215523b_egets
beiges91014413beig_es
beignes10149243beignes
beignets11155373beignets
beknights1942243beknights
bidets95215533b_idets
bighted142810923b_ighted
bigos85020013b_ig_os
bigot84828323b_igot_
bigs76235023b_ig__s
bilges94915633bilg_es
billets94516153billets
binits85716673b_inits
bints76130183b_i_nts
bionts8612393b_ionts
births115713603b_irths
bits66148163b_i__ts
bitts75022593b_i_tts
blahs105616513bl_ah_s
blasts85116773bl_asts
blats75132503bl__ats
bleats85518613bl_eats
blets75324943bl__ets
blighting1635733blighting
blimps12588153bli_mps
blindguts1341453blindguts
blinds95111613bli_nds
blinis85313683bli_nis
blinks124613573bli_nks
blintz1788843bli_ntz
blips95615783bli__ps
bliss75616913bli__ss
blisses94911513blisses
blite76225353bli__te
blites84721213bli_tes
blithe115810863blith_e
blither124812173blither
blithers134711233blithers
blithest1338083blithest
blitz165318133bli__tz
blitzes18408703blitzes
bloats85215763bl_oats
blogs85319233blog__s
blots75626173bl__ots
bluets87215493bl_uets
blunts84512893bl_unts
blurts84412643bl_urts
blushes124314823blushes
borshts1266543borshts
boughs125414373bough_s
bought125115633bought_
brighten1466243brighten
brightens1565373brightens
brighter1476663brighter
brightest1545663brightest
brightish1863663brightish
brightly1764553brightly
brigs85823223brig__s
briths115113863brith_s
brits76433083bri__ts
britts84813443bri_tts
brughs12509063brugh_s
budgets11489863budgets
bullfights1951973bullfights
burghs12519923burgh_s
claughts1443383claughts
cliches144213743cliches
clients938093clients
clifts11519153cli_fts
daylights1743283daylights
delight12610673delight_
dight104027003_dight_
digits84114533_digits
eight94928053_eight_
eighth133310603_eighth
eighths14388293_eighths
eighty133711603_eighty
elegits8149343elegits
elicits9311233elicits
elints65816423eli_nts
fanlights1643923fanlights
fight124027093_fight_
flighted1646973flighted
flints95617453fli_nts
flirts95411483fli_rts
flits85625223fli__ts
freights1555853freights
fright133715243fright_
gaslights1463753gaslights
gigots83911953_gigots
glints75714213gli_nts
height134713433height_
heighth13366343heighth
heighths14324823heighths
highs125412523_high_s
hight125327233_hight_
highth12389153_highth
highths13358003_highths
infights1545573infights
insights1245493insights
klephts1642183klephts
knight1438173knight_
laighs10508803laigh_s
legits71313003_legits
liches114724293_liches
lichis115212593_lichis
licht104723493_licht_
lifts85719063_li_fts
ligans76817733_ligans
ligate72519253_ligate
ligates82318383_ligates
ligers75022043_ligers
lighted122913503_lighted
lighten112811523_lighten
lightens122510003_lightens
lighter113113443_lighter
lighters123111393_lighters
lightest121410353_lightest
lightish1556623_lightish
lightly14369023_lightly
lilts55822803_li_lts
limits82514143_limits
lints57137193_li_nts
lists56628693_li_sts
lithos94212553_lithos
lits46252493_li__ts
lowlights1643653lowlights
might113827083_might_
mighty154310203_mighty
mislights1544663mislights
naughts11447513naughts
neighs10387733neigh_s
nighs95013613_nigh_s
night94327853_night_
nighty135611273_nighty
noughts11478083noughts
obligate11198303obligate
obligates12207853obligates
obligati11184833obligati
obligato11194983obligato
obligatos12195063obligatos
obligees1143953obligees
obligers1134723obligers
obliges1037143oblig_es
obligors1143523obligors
oughts104710183_oughts
penlights1544203penlights
plighted1546463plighted
plighter1476623plighter
plighters1545533plighters
plinths1236123plinths
refights1555883refights
relight11512063relight_
resights1246733resights
right94430503_right_
righto104111093_righto
righty135011833_righty
sighs95416743_sigh_s
sight94629293_sight_
skylights2042843skylights
sleighs11245673sleigh_s
sleight11279023sleight_
slighted1357393slighted
slighter1257823slighter
slighters1346713slighters
slightest13136943slightest
slightly1544603slightly
slits56128853sli__ts
spigots1037793spigots
sprights14167143sprights
sunlights1344003sunlights
thighs1346633thigh_s
tight93626503_tight_
tonights1244593tonights
twilights1642533twilights
unsights1244623unsights
uplight13167363uplight_
uprights14145313uprights
waughts14355963waughts
weighs13338873weigh_s
weight133914183weight_
weighty17376233weighty
whishts16425313whishts
wight123725573_wight_
wright133713513wright_

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 Limit1340272396.69020033.9
3Display Results2392390.0763144.7
 (SQL Overall)1786912397.16924925.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.