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

143 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
plighted154646(None) 
alighted1347671alighted
blighted1546861blighted
flighted1646971flighted
lighted122913501_lighted
plighter1476621plighter
slighted1357391slighted
uplighted1653841uplighted
bighted142810922_bighted
blighter1466852blighter
delighted1546202delighted
dighted132511492_dighted
frighted1657172frighted
highted152710162_highted
knighted1745122knighted
lichted13268802_lichted
ligated92414132_ligated
lighten112811522_lighten
lighter113113422_lighter
plicated13310642plicated
plight123513362plight__
plighters1545522plighters
plights13299312plight_s
relighted1436862relighted
righted122912142_righted
sighted123111522_sighted
slighter1257822slighter
unlighted1455772unlighted
uprighted1654212uprighted
weighted1635592weighted
alight103816863alight__
alights113211433alight_s
aligned9128553alig_ned
bedighted1744583bedighted
benighted1644743benighted
bigoted11258403_bigoted
blight124114623blight__
blighters1555733blighters
blighties1546223blighties
blights133110213blight_s
blighty16356843blight_y
brighten1466243brighten
brighter1476663brighter
claughted1643243claughted
cliched153711023clich_ed
daylighted1952193daylighted
delighter1445583delighter
elicited1139093elicited
enlighten1344353enlighten
fighter143010763_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
ligate72519243_ligate_
ligates82318373_ligates
light94429603_light__
lightened1446023_lightened
lightens12259993_lightens
lightered1446263_lightered
lighters123111373_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
obligated13186903obligated
oughted1236223_oughted
painted104214633pai_nted
pargeted1238673pargeted
picoted1239213p_icoted
pigged114214153p_ig_ged
pigweed1465093p_igweed
pileated112711133pileated
piloted10310323p_iloted
pirated102515613p_irated
pished124817063p_ish_ed
pithed124615613p_ith_ed
pitted94319593p_i_tted
pivoted1336513p_ivoted
placated1338453placated
plagued11307473plag_ued
plaited103713893pl_aited
planted103516123pl_anted
plashed133712643plash_ed
plated95225773pl__ated
platted103614263pl_atted
pleated103816633pl_eated
plicate11314513plicate_
plied85118593pli___ed
plighting1635563plighting
plinked143910893pli_nked
plotted104612373pl_otted
ploughed15204303plough_ed
plugged12408033plug_ged
pointed103813983poi_nted
polished1468433polish_ed
preflighted2172783preflighted
priested1138393priested
prigged12398923prig_ged
printed104016373pri_nted
resighted1436523resighted
righter113212373_righter
sighed113712053_sigh_ed
sighter113412103_sighter
skylighted2251803skylighted
sleighed1334033sleigh_ed
slight103416003slight__
slighters1346703slighters
slightest13136943slightest
slightly1544603slightly
slights112810723slight_s
slitted83513313sli_tted
splinted11369253spli_nted
spotlighted1851663spotlighted
thighed1535263thigh_ed
tighten11288973_tighten
tighter112910683_tighter
unsighted1455423unsighted
uplifted1454423upli_fted
uplight13167363uplight__
uplights14165053uplight_s
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 Limit1461621437.48619524.7
3Display Results1431430.0602383.3
 (SQL Overall)1786911437.70223200.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.