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

154 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
blighter146685(None) 
blighted1546861blighted
blighters1555741blighters
brighter1476661brighter
lighter113113441_lighter
plighter1476621plighter
slighter1257821slighter
alighted1347672alighted
bighted142810922b_ighted
blight124114622blight__
blighties1546222blighties
blights133110212blight_s
blighty16356842blight_y
blister94415312bli_ster
blither124812172blith_er
brighten1466242brighten
delighter1445582delighter
fighter143010772_fighter
flichter1664962flichter
flighted1646972flighted
flightier1644422flightier
lighted122913502_lighted
lighten112811522_lighten
lighters123111392_lighters
plighted1546462plighted
plighters1545532plighters
righter113212382_righter
sighter113412112_sighter
slighted1357392slighted
slighters1346712slighters
tighter112910692_tighter
weighter1535602weighter
alight103816863alight__
alights113211433alight_s
aligner8108313alig_ner
baiter84422553bai__ter
bedighted1744583bedighted
benighted1644743benighted
bigger104315063b_ig_ger
bight118728843b_ight__
bights124417963b_ight_s
bigoted11258403b_igoted
bilgier10358533bilg_ier
billeter1037563billeter
bister84922763b_i_ster
biter75030033b_i__ter
bitter84622673b_i_tter
blaster94017303bl_aster
blather125314203blath_er
blatter94415653bl_atter
bleater94515303bl_eater
blether12459913bleth_er
blighting1635733blighting
blinder103912983bli_nder
blinker134110213bli_nker
blisters104015083bli_sters
blistery13418713bli_stery
blite76225353bli__te_
blites84721213bli__tes
blithe115810863blith_e_
blithers134711233blith_ers
blitzer18447663bli_tzer
bloater94013423bl_oater
blogger11448313blog_ger
blotter94612853bl_otter
blucher143310223bluch_er
blunter94512033bl_unter
blurter9419833bl_urter
blusher124113113blush_er
bluster94215313bl_uster
boughten1444193boughten
bright124215923bright__
brightener1652963brightener
brightens1565373brightens
brightest1545663brightest
brightly1764553brightly
brights133710233bright_s
budgeter1244543budgeter
bullfighter2051293bullfighter
burgher1337003burgh_er
daughter1344503daughter
delighted1546203delighted
delighters1544363delighters
dighted132511493_dighted
enlighten1344353enlighten
fighters15269403_fighters
flichters1774173flichters
flight134014813flight__
flights143310983flight_s
flighty17347433flight_y
flirter10318673fli_rter
flitter103413903fli_tter
freighter1655023freighter
frighted1657173frighted
frighten1566443frighten
glister84013343gli_ster
glitter84211803gli_tter
heighten1545703heighten
higher134610893_high_er
highted152710163_highted
infighter1644273infighter
klister113410643kli_ster
knighted1745123knighted
laughter1245113laughter
lichted13268803_lichted
lifter93814813_li_fter
ligate72519253_ligate_
ligated92414143_ligated
ligates82318383_ligates
liger65024473_lig__er
light94429603_light__
lightener1345693_lightener
lightens122510003_lightens
lightered1446283_lightered
lightest121410353_lightest
lightly14369023_lightly
lights104519913_light_s
limiter92710853_limiter
linter64625343_li_nter
lister64527253_li_ster
liter54736343_li__ter
lither94520953_lith_er
litter64324853_li_tter
mightier1436383_mightier
nigher103612753_nigh_er
obligate11198303obligate_
obligated13186903obligated
obligates12207853obligates
obligator12195693obligator
obliger1035283oblig__er
oligomer1144023oligomer
plight123513363plight__
plights13299313plight_s
relighted1436863relighted
righted122912143_righted
righters122610713_righters
sigher103813703_sigh_er
sighted123111523_sighted
sighters122510603_sighters
slaughter1344003slaughter
sleigher1234313sleigh_er
slight103416003slight__
slightest13136943slightest
slightly1544603slightly
slights112810723slight_s
slither104112983slith_er
slitter73615873sli_tter
tighten11288973_tighten
unlighted1455783unlighted
uplighted1653843uplighted
weigher14136343weigh_er
weighted1635593weighted
weighters1644673weighters
weightier1643313weightier

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.453394461.4
2DLD Change Limit1461621546.69021847.8
3Display Results1541540.0602566.7
 (SQL Overall)1786911547.20324807.9
 
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.