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

144 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
brighter147666(None) 
blighter1466851blighter
brighten1466241brighten
righter113212381_righter
bighted142810922b_ighted
blighted1546862blighted
blighters1555742blighters
bright124215922bright__
brightener1652962brightener
brightens1565372brightens
brightest1545662brightest
brightly1764552brightly
brights133710232bright_s
fighter143010772_fighter
freighter1655022freighter
frighted1657172frighted
frighten1566442frighten
lighter113113442_lighter
plighter1476622plighter
righted122912142_righted
righters122610712_righters
sighter113412112_sighter
slighter1257822slighter
tighter112910692_tighter
weighter1535602weighter
alighted1347673alighted
aright103817663aright__
baiter84422563bai__ter
bedighted1744583bedighted
benighted1644743benighted
bigger104315063b_ig_ger
bight118728843b_ight__
bights124417963b_ight_s
bigoted11258403b_igoted
bister84922763b_i_ster
biter75030033b_i__ter
bitter84622673b_i_tter
blight124114623blight__
blighties1546223blighties
blights133110213blight_s
blighty16356843blight_y
blister94415313bli_ster
blither124812173blith_er
boughten1444193boughten
bragger113810043brag_ger
braggier12136453braggier
brasher124515243brash_er
brashier13389933brashier
breather133610603breather
briber104714053bri__ber
brickier16307163brickier
bridler103811073bri_dler
briefer1235563bri_efer
brier74527403bri___er
brigade1136493brigade_
brigaded1344573brigaded
brigades1236393brigades
brigadier1343323brigadier
brightened1743163brightened
brighteners1752863brighteners
brightish1863663brightish
brightness1644573brightness
brightwork2361913brightwork
brimmer13348803bri_mmer
briner84519043bri__ner
bringer104213353bri_nger
brinier93613473bri_nier
brisker134210293bri_sker
brittler10165983brittler
brother123311333broth_er
bruiter93710633br_uiter
brusher123813003brush_er
brushier13306973brushier
budgeter1244543budgeter
burgher1337003burgh_er
critter94113033cri_tter
daughter1344503daughter
delighter1445583delighter
dighted132511493_dighted
dragster1034633dragster
drifter11348703dri_fter
fighters15269403_fighters
flichter1664963flichter
flighted1646973flighted
flightier1644423flightier
freighted1755203freighted
freighters1764123freighters
frigate11311063frigate_
frigates12310933frigates
fright133715243fright__
frightens1655393frightens
frights14339623fright_s
fritter103912773fri_tter
grifter113810493gri_fter
grister83915413gri_ster
gritter83913353gri_tter
heighten1545703heighten
higher134610893_high_er
highted152710163_highted
infighter1644273infighter
knighted1745123knighted
laughter1245113laughter
lighted122913503_lighted
lighten112811523_lighten
lighters123111393_lighters
mightier1436383_mightier
nigher103612753_nigh_er
orienter838313orienter
plighted1546463plighted
plighters1545533plighters
printer93917303pri_nter
privater13158533privater
richer114015043_rich_er
rigger85616713_rig_ger
right94430503_right__
rightest12149583_rightest
righties12711573_righties
rightly14389043_rightly
righto104111093_right_o
rights104019333_right_s
righty135011833_right_y
rioter64817283_ri_oter
ritter63822423_ri_tter
riveter10208753_riveter
sigher103813703_sigh_er
sighted123111523_sighted
sighters122510603_sighters
slighted1357393slighted
slighters1346713slighters
straighter1444493straighter
tighten11288973_tighten
trigger9329163trig_ger
trimeter10310083trimeter
triter65120593tri__ter
uprighted1654213uprighted
weigher14136343weigh_er
weighted1635593weighted
weighters1644673weighters
weightier1643313weightier
wriggler13295263wriggler
wright133713513wright__
wrights14318993wright_s
writer94416513wri__ter
writher134010853writh_er

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.406440125.6
2DLD Change Limit1461621447.47019566.5
3Display Results1441440.0463130.4
 (SQL Overall)1786911447.92222556.3
 
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.