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

149 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
blighted154686(None) 
alighted1347671alighted
bighted142810921b_ighted
blighter1466851blighter
flighted1646971flighted
lighted122913501_lighted
plighted1546461plighted
slighted1357391slighted
bedighted1744582bedighted
benighted1644742benighted
bigoted11258402b_igoted
blight124114622blight__
blighters1555742blighters
blighties1546222blighties
blights133110212blight_s
blighty16356842blight_y
brighten1466242brighten
brighter1476662brighter
delighted1546202delighted
dighted132511492_dighted
frighted1657172frighted
highted152710162_highted
knighted1745122knighted
lichted13268802_lichted
ligated92414142_ligated
lighten112811522_lighten
lighter113113442_lighter
obligated13186902obligated
plighter1476622plighter
relighted1436862relighted
righted122912142_righted
sighted123111522_sighted
slighter1257822slighter
unlighted1455782unlighted
uplighted1653842uplighted
weighted1635592weighted
alight103816863alight__
alights113211433alight_s
aligned9128553alig_ned
backlighted2452813backlighted
baited95319243bai__ted
beknighted2151863beknighted
bighead14126653b_ighead
bight118728843b_ight__
bights124417963b_ight_s
bilged105513183bilg__ed
billeted1137643billeted
bilsted1038033b_ilsted
birthed13228593b_irthed
bitted94418483b_i_tted
blasted104213473bl_asted
blatted104812713bl_atted
bleated104015973bl_eated
blighting1635733blighting
blinded114810023bli_nded
blinked144010013bli_nked
blipped14377193bli_pped
blissed10388373bli_ssed
blister94415313bli_ster
blite76225353bli__te_
blites84721213bli__tes
blithe115810863blith_e_
blither124812173blith_er
blithered15156123blithered
blitzed19336533bli_tzed
bloated104513433bl_oated
blotted103911833bl_otted
blunted104210663bl_unted
blurted10399783bl_urted
blushed134411753blush_ed
boughed143810263bough_ed
boughten1444193boughten
brigaded1344573brigaded
bright124215923bright__
brightened1743163brightened
brightens1565373brightens
brightest1545663brightest
brightly1764553brightly
brights133710233bright_s
budgeted1344883budgeted
claughted1643243claughted
cliched153711023clich_ed
daylighted1952193daylighted
delighter1445583delighter
elicited1139093elicited
enlighten1344353enlighten
fighter143010773_fighter
flichter1664963flichter
flight134014813flight__
flightier1644423flightier
flights143310983flight_s
flighty17347433flight_y
flinted114411893fli_nted
flirted11428673fli_rted
flited104616583fli__ted
flitted114011643fli_tted
freighted1755203freighted
frighten1566443frighten
glinted9399373gli_nted
heighten1545703heighten
legated92513983_legated
lifted104413523_li_fted
ligate72519253_ligate_
ligates82318383_ligates
light94429603_light__
lightened1446023_lightened
lightens122510003_lightens
lightered1446283_lightered
lighters123111393_lighters
lightest121410353_lightest
lightly14369023_lightly
lights104519913_light_s
lilted73715373_li_lted
limited102310233_limited
linted74021823_li_nted
listed74322833_li_sted
lithoed1137833_lithoed
mislighted1743653mislighted
neighed12135893neigh_ed
nighed113811293_nigh_ed
obligate11198303obligate_
obligates12207853obligates
obliged1134983oblig__ed
oughted1236223_oughted
plicated13310643plicated
plight123513363plight__
plighters1545533plighters
plights13299313plight_s
resighted1436523resighted
righter113212383_righter
sighed113712053_sigh_ed
sighter113412113_sighter
skylighted2251803skylighted
sleighed1334033sleigh_ed
slight103416003slight__
slighters1346713slighters
slightest13136943slightest
slightly1544603slightly
slights112810723slight_s
slitted83513313sli_tted
thighed1535273thigh_ed
tighten11288973_tighten
tighter112910693_tighter
unsighted1455433unsighted
uprighted1654213uprighted
waughted1643483waughted
weighed15135933weigh_ed
weighter1535603weighter
whishted1843153whishted

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621496.79621507.1
3Display Results1491490.0632365.1
 (SQL Overall)1786911497.01525472.7
 
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.