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

264 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
brights13371023(None) 
bights124417961b_ights
blights133110211blights
bright124215921bright_
frights14339621frights
rights104019331_rights
wrights14318991wrights
alights113211432alights
aright103817662aright_
bedights1544742bedights
bight118728842b_ight_
bigots95015132b_igots
blight124114622blight_
blighty16356842blighty
brighten1466242brighten
brightens1565372brightens
brighter1476662brighter
brightest1545662brightest
brightish1863662brightish
brightly1764552brightly
brigs85823222brig__s
briths115113862brith_s
brits76433082bri__ts
britts84813442bri_tts
brughs12509062brugh_s
dights114016962_dights
eights103618982_eights
fights133816552_fights
flights143310982flights
freights1555852freights
fright133715242fright_
heights14399442heights
hights133716892_hights
knights1545652knights
lights104519912_lights
mights123516252_mights
nights104117722_nights
plights13299312plights
right94430502_right_
righto104111092_righto
righty135011832_righty
sights103818012_sights
slights112810722slights
sprights14167142sprights
tights104015852_tights
uprights14145312uprights
weights14409552weights
wights133315782_wights
wright133713512wright_
affrights1942893affrights
alight103816863alight_
alright1148853alright_
argots74116033ar_gots
aughts104710243_aughts
bahts105617803b__ahts
baits76630583bai__ts
bedight1437483bedight_
begets96215523b_egets
beiges91014413beig_es
beignes10149243beignes
beignets11155373beignets
beknights1942243beknights
bidets95215533b_idets
bighted142810923b_ighted
bigos85020013b_ig_os
bigot84828323b_igot_
bigs76235023b_ig__s
binits85716673b_inits
bints76130183b_i_nts
bionts8612393b_ionts
birches143412323birches
births115713603birth_s
bits66148163b_i__ts
bitts75022593b_i_tts
blighted1546863blighted
blighter1466853blighter
blighters1555743blighters
blighties1546223blighties
borschts1542853borschts
borshts1266543borshts
boughs125414373bough_s
bought125115633bought_
braches144621223braches
brachets154311983brachets
brachs134415753brach_s
bracts105617773br_acts
brags85625103brag__s
brants85723053br_ants
brashes124518463brashes
brats75336013br__ats
breasts939703breasts
breaths124411183breaths
brents84717273br_ents
brevets12519393brevets
briards10398553briards
briars84814823bri_ars
bribees11409283bribees
bribers114111503bribers
bribes105918533bri_bes
bricks144614623bri_cks
bridals1038623bridals
brides94423513bri_des
bridges113911333bridges
bridles104114473bridles
briefs115510073bri_efs
briers85319733bri_ers
bries74942153bri__es
brig76528033brig___
brigade1136493brigade
brigades1236393brigades
brigand1136643brigand
brigands1245623brigands
brightness1644573brightness
brillos9369183brillos
brills84916293bri_lls
brims94721623bri__ms
briners94315633briners
brines85028853bri_nes
bringers112811073bringers
brings94618433bri_ngs
brinies93317913brinies
brinks124616313bri_nks
brins75533973bri__ns
brioches15227253brioches
brios74725723bri__os
briquets1934853briquets
bris65539613bri___s
brises84927613bri_ses
briskets14346563briskets
brisks124611403bri_sks
briss75824273bri__ss
brisses94314313brisses
brit66350153bri__t_
britches15278683britches
brith104924373bri__th
britt75732233bri__tt
brogans1049663brogans
brogues10719823brogues
broths115013923broth_s
brought13308683brought_
brugh115414293brugh__
bruits85714453br_uits
brulots946223brulots
brunets9419553brunets
brunts85215453br_unts
brushes124014663brushes
bruts75922953br__uts
budgets11489863budgets
burghs12519923burgh_s
crits75527573cri__ts
delights1347333delights
dight104027003_dight_
digits84114533_digits
draughts13284753draughts
drifts10499893dri_fts
droughts13245733droughts
eight94928053_eight_
eighth133310603_eighth
eighths14388293_eighths
eighty133711603_eighty
ergots74512373er_gots
eyebrights1951353eyebrights
fight124027093_fight_
flight134014813flight_
flighty17347433flighty
fraughts15214243fraughts
freight1447603freight_
frigate11311063frigate
frigates12310933frigates
friges104116483frig_es
frighted1657173frighted
frighten1566443frighten
frightens1655393frightens
frigs96019273frig__s
friths124313583frith_s
frits86129103fri__ts
fritts94613193fri_tts
gigots83911953_gigots
grifts104511683gri_fts
grigris934093grigris
grigs75318193grig__s
griots74713643gri_ots
grists74716483gri_sts
griths105211653grith_s
grits65529583gri__ts
grivets11357973grivets
height134713433height_
heighth13366343heighth
heighths14324823heighths
highs125412523_high_s
hight125327233_hight_
highth12389153_highth
highths13358003_highths
infights1545573infights
insights1245493insights
knight1438173knight_
laighs10508803laigh_s
lichts113712383_lichts
light94429603_light_
might113827083_might_
mighty154310203_mighty
naughts11447513naughts
neighs10387733neigh_s
nighs95013613_nigh_s
night94327853_night_
nighty135611273_nighty
noughts11478083noughts
orients7311583orients
origans839973origans
origins8310463origins
orishas1036473orishas
oughts104710183_oughts
plight123513363plight_
priests93810863priests
prigs85219703prig__s
prints84320103pri_nts
privets122910053privets
refights1555883refights
relights1248053relights
resights1246733resights
riches115022083_riches
rifts85718643_ri_fts
righted122912143_righted
righter113212383_righter
righters122610713_righters
rightest12149583_rightest
righties12711573_righties
rightism14156963_rightism
rightist12159143_rightist
rightly14389043_rightly
rigors72813713_rigors
rigs55137593_rig__s
riots54922013_ri_ots
rishis9312453_rishis
rivets94417113_rivets
sighs95416743_sigh_s
sight94629293_sight_
sleights12275913sleights
slight103416003slight_
spigots1037793spigots
spright132010403spright_
straights1345813straights
thighs1346633thigh_s
tight93626503_tight_
tonights1244593tonights
tricots9311563tricots
trigons84312093trigons
trigos74214173trig_os
trigs65423063trig__s
trijets14308263trijets
trivets103911583trivets
unbright1444703unbright_
unsights1244623unsights
uplights14165053uplights
upright13178293upright_
waughts14355963waughts
weighs13338873weigh_s
weight133914183weight_
weighty17376233weighty
whishts16425313whishts
wight123725573_wight_
wrists95415643wri_sts
writhes134811703writhes
writs86624383wri__ts

Search took 7 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 Filter1786911340270.390458182.1
2DLD Change Limit1340272646.30021274.1
3Display Results2642640.0932838.7
 (SQL Overall)1786912646.78326343.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.