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

247 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
weight13391418(None) 
eight94928051_eight
height134713431height
weigh125412511weigh_
weighs13338871weighs
weights14409551weights
weighty17376231weighty
wight123725571w_ight
wright133713511wright
alight103816862alight
aright103817662aright
aweigh1334932aweigh_
bedight1437482bedight
bight118728842_bight
blight124114622blight
bright124215922bright
delight12610672delight
dight104027002_dight
eighth133310602_eighth
eights103618982_eights
eighty133711602_eighty
fight124027092_fight
flight134014812flight
freight1447602freight
fright133715242fright
heigh124812542heigh_
heighth13366342heighth
heights14399442heights
hight125327232_hight
knight1438172knight
light94429602_light
might113827082_might
neigh94912382neigh_
neighs10387732neighs
night94327852_night
plight123513362plight
refight1488872refight
relight11512062relight
resight11510642resight
right94430502_right
sight94629292_sight
sleight11279022sleight
slight103416002slight
tight93626502_tight
unweight1544742unweight
waught133811042waught
wecht13415442we_cht
weighed15135932weighed
weigher14136342weigher
weighted1635592weighted
weighter1535602weighter
whisht154510812whisht
wights133315782w_ights
wrights14318992wrights
alights113211433alights
alright1148853alright
aught95120703_aught
bedights1544743bedights
begat86629723be_gat
beget85632563be_get
begirt9412683begirt
begot84625953be_got
beige81515383beig_e
beiges91014413beiges
beigne9148613beigne
beignet101510963beignet
beigy111110583beig_y
beknight1843563beknight
bights124417963_bights
bigot84828323_bigot
blights133110213blights
blighty16356843blighty
bought125115633bought
brights133710233brights
caught124911683caught
deign74312803deig_n
deigns8389983deigns
deist64633593dei_st
delights1347333delights
dights114016963_dights
digit73825273_digit
dought114915513dought
dreigh11246443dreigh_
echt95722903_e_cht
eighths14388293_eighths
eightvo1443843_eightvo
ergot65422893_ergot
eyesight1543513eyesight
feign94210713feig_n
feigns10407753feigns
feint84732253fei_nt
feist86230073fei_st
fights133816553_fights
flights143310983flights
flighty17347433flighty
flyweight2252533flyweight
fought135112393fought
freights1555853freights
frights14339623frights
geisha1035203geisha
gighe10139733_gighe
gigot74023073_gigot
heighten1545703heighten
heighths14324823heighths
heishi1235843heishi
heist87030913hei_st
heugh125410923heugh_
heughs13516903heughs
high116619923_high_
highs125412523_highs
highth12389153_highth
hights133716893_hights
infight1437453infight
insight1137913insight
knights1545653knights
laigh95515923laigh_
laighs10508803laighs
legist71315253legist
legit61323503le_git
length1046103length
licht104723493_licht
lights104519913_lights
lowlight1554943lowlight
mights123516253_mights
mighty154310203_mighty
naught104312493naught
neighed12135893neighed
neist54628443nei_st
nigh85220663_nigh_
nighs95013613_nighs
nights104117723_nights
nighty135611273_nighty
nought104713963nought
ought95221533_ought
penlight1446423penlight
plights13299313plights
prefight1746393prefight
refights1555883refights
regilt71217493regilt
reign65015193reig_n
reigns74811753reigns
relights1248053relights
resights1246733resights
reweigh1464773reweigh_
reweighs1583203reweighs
righto104111093_righto
rights104019333_rights
righty135011833_righty
seiche11811833seiche
sennight1245143sennight
sigh85625893_sigh_
sighs95416743_sighs
sights103818013_sights
skeigh14265903skeigh_
sleigh10258203sleigh_
sleighs11245673sleighs
sleights12275913sleights
slights112810723slights
sought106315053sought
spigot9312603spigot
spright132010403spright
taught104312223taught
teugh95511613teugh_
thigh12410123thigh_
thighs1346633thighs
tights104015853_tights
tonight1138743tonight
twilight1543903twilight
twinight1543073twinight
unsight1137483unsight
unweights1643203unweights
uplight13167363uplight
upright13178293upright
uptight13176033uptight
waist86132383wai_st
wait75553693wai__t
waucht14399413waucht
waugh125411683waugh_
waughts14355963waughts
wealth12379223wealth
wechts1446253we_chts
wedge105215663wedg_e
wedged125110303wedged
wedges114614583wedges
wedgie11428373wedgie
wedgy13479803wedg_y
weeknight20112123weeknight
weest85026773we_est
weet75254153we__et
weft105435013we__ft
weigela1143073weigela
weighers15135673weighers
weighing1635283weighing
weighman1742483weighman
weighmen1743463weighmen
weighters1644673weighters
weightier1643313weightier
weightily1942463weightily
weighting1744783weighting
weiner94214133weiner
weir76019923wei__r
weird95111283wei_rd
weirdo10405883weirdo
weirds10478053weirds
weirdy13395463weirdy
weirs84316493wei_rs
welch134411493welch_
welsh113110363welsh_
welt75547863we__lt
wench136214783wench_
went76051873we__nt
wept95635053we__pt
wergelt1138583wergelt
wert79749823we__rt
weskit1338343weskit
west75748083we__st
wet65966623we___t
which163910083which_
whig115516423whig__
whigs125612643whig_s
whilst1239143whilst
whipt135317423whi_pt
whish144512923whish_
whishts16425313whishts
whist115322953whi_st
whit104834173whi__t
wich125724743w_ich_
widget113815263widget
width12310963w_idth
wig76740383w_ig__
wigan95114393w_igan
wiggy134510733w_iggy
wiglet105519153w_iglet
wigs84931253w_ig_s
wilt76246293w_i_lt
wish107228733w_ish_
wisha114910853w_isha
wist78049293w_i_st
wit66563773w_i__t
with105730473w_ith_
withe115220233w_ithe
withy144813763w_ithy
wriest94419713wriest
wrist84827563wri_st
writ75537913wri__t
writhe125310703writhe
wrought14276923wrought

Search took 6 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 Filter1786911127160.393454684.5
2DLD Change Limit1127162474.96622697.5
3Display Results2472470.0803087.5
 (SQL Overall)1786912475.43932853.6
 
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.