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

171 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
flighted164697(None) 
alighted1347671alighted
blighted1546861blighted
frighted1657171frighted
lighted122913501_lighted
plighted1546461plighted
slighted1357391slighted
bighted142810922_bighted
blighter1466852blighter
delighted1546202delighted
dighted132511492_dighted
fighter143010772f_ighter
flichter1664962flichter
flight134014812flight__
flightier1644422flightier
flights143310982flight_s
flighty17347432flight_y
flinted114411892fli_nted
flirted11428672fli_rted
flited104616582fli__ted
flitted114011642fli_tted
freighted1755202freighted
frighten1566442frighten
highted152710162_highted
knighted1745122knighted
lichted13268802_lichted
ligated92414142_ligated
lighten112811522_lighten
lighter113113442_lighter
plighter1476622plighter
relighted1436862relighted
righted122912142_righted
sighted123111522_sighted
slighter1257822slighter
unlighted1455782unlighted
uplighted1653842uplighted
weighted1635592weighted
affrighted2152053affrighted
alight103816863alight__
alights113211433alight_s
aligned9128553alig_ned
bedighted1744583bedighted
benighted1644743benighted
bigoted11258403_bigoted
blight124114623blight__
blighters1555743blighters
blighties1546223blighties
blights133110213blight_s
blighty16356843blight_y
brighten1466243brighten
brighter1476663brighter
claughted1643243claughted
cliched153711023clich_ed
daylighted1952193daylighted
delighter1445583delighter
elicited1139093elicited
enlighten1344353enlighten
faggoted1443103faggoted
fagoted1236073f_agoted
fainted114211723fai_nted
faithed1437163faith_ed
farsighted1842943farsighted
feigned1245353feig_ned
feinted11379623fei_nted
fidgeted1443893fidgeted
figged124013893f_ig_ged
fight124027093f_ight__
fighters15269403f_ighters
fights133816553f_ight_s
figured12196473f_igured
filched16307423filch_ed
fileted1159093f_ileted
filiated12610083filiated
filigreed1482443filigreed
filleted1236603filleted
fished134316313f_ish_ed
fisted104218703f_i_sted
fitted104716663f_i_tted
fixated1835533f_ixated
flagged13459633flag_ged
flashed144112183flash_ed
flatted114012943fl_atted
flaunted1234603flaunted
fleeted113310233fl_eeted
fleshed143210263flesh_ed
flichtered1942133flichtered
flichters1774173flichters
flicked174610673fli_cked
flied96519433fli___ed
flightiest1744513flightiest
flightily1943353flightily
flighting1736103flighting
flightless1773393flightless
flinched17316703flinched
flinthead1642303flinthead
flipped15358513fli_pped
flirter10318673fli_rter
flitched17256293flitched
flite85424963fli__te_
flites95122443fli__tes
flitter103413903fli_tter
floated113312703fl_oated
flogged13528803flog_ged
flouted113210813fl_outed
flushed143310973flush_ed
fluted104917163fl__uted
flyted13378773fl__yted
foisted113210603foi_sted
foliated1249913foli_ated
foughten1544003foughten
fraughted1743603fraughted
freighter1655023freighter
frigate11311063frigate_
frigates12310933frigates
frigged13439053frig_ged
fright133715243fright__
frightened1843243frightened
frightens1655393frightens
frights14339623fright_s
fritted113611333fri_tted
fumigated1644723fumigated
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
obligated13186903obligated
oughted1236223_oughted
plicated13310643plicated
plight123513363plight__
plighters1545533plighters
plights13299313plight_s
preflighted2172783preflighted
resighted1436523resighted
righter113212383_righter
sighed113712053_sigh_ed
sighter113412113_sighter
skylighted2251803skylighted
sleighed1334033sleigh_ed
slight103416003slight__
slighters1346713slighters
slightest13136953slightest
slightly1544603slightly
slights112810723slight_s
slitted83513313sli_tted
thighed1535273thigh_ed
tighten11288973_tighten
tighter112910693_tighter
unsighted1455433unsighted
uprighted1654213uprighted
waughted1643483waughted
weighed15135933weigh_ed
weighter1535603weighter
whishted1843153whishted

Search took 10 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.436409841.7
2DLD Change Limit1461621719.01616211.4
3Display Results1711710.0632714.3
 (SQL Overall)1786911719.51518779.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.