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

125 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
weighted163559(None) 
weighed15135931weigh_ed
weighter1535601weighter
alighted1347672alighted
bedighted1744582bedighted
benighted1644742benighted
bighted142810922_bighted
blighted1546862blighted
delighted1546202delighted
dighted132511492_dighted
flighted1646972flighted
freighted1755202freighted
frighted1657172frighted
heighten1545702heighten
highted152710162_highted
knighted1745122knighted
lighted122913502_lighted
neighed12135892neigh_ed
plighted1546462plighted
relighted1436862relighted
resighted1436522resighted
righted122912142_righted
sighted123111522_sighted
slighted1357392slighted
unweighted1843152unweighted
waughted1643482waughted
weigher14136342weigh_er
weighmen1743462weighmen
weight133914182weight__
weighters1644672weighters
weightier1643312weightier
weights14409552weight_s
weighty17376232weight_y
whishted1843152whishted
beknighted2151863beknighted
bigoted11258403_bigoted
blighter1466853blighter
brighten1466243brighten
brighter1476663brighter
deigned1037503deig_ned
delighter1445583delighter
eight94928053_eight__
eighteen1245763_eighteen
eighth133310603_eight_h
eighths14388293_eighths
eighties12710803_eighties
eights103618983_eight_s
eightvo1443843_eightvo
eighty133711603_eight_y
feigned1245353feig_ned
feinted11379623fei_nted
fighter143010773_fighter
freighter1655023freighter
frighten1566443frighten
height134713433height__
heightened1843013heightened
heightens1644713heightens
heighth13366343height_h
heighths14324823heighths
heights14399443height_s
heisted113210653hei_sted
legated92513983le_gated
levigated1445643levigated
lichted13268803_lichted
ligated92414143_ligated
lighten112811523_lighten
lighter113113443_lighter
negated93413233ne_gated
nighed113811293_nigh_ed
oughted1236223_oughted
plighter1476623plighter
reigned949213reig_ned
reignited1145683reignited
retighten1374773retighten
reweighed1742903reweigh_ed
righter113212383_righter
sighed113712053_sigh_ed
sighter113412113_sighter
sleighed1334033sleigh_ed
slighter1257823slighter
thighed1535273thigh_ed
tighten11288973_tighten
tighter112910693_tighter
unlighted1455783unlighted
unsighted1455433unsighted
unweighed1753663unweigh_ed
uplighted1653843uplighted
uprighted1654213uprighted
waisted114210943wai_sted
waited103819773wai__ted
wauchted1753373wauchted
wedged125110303wedg__ed
weeted103913793we__eted
weigh125412513weigh___
weighers15135673weighers
weighing1635283weighing
weighman1742483weighman
weighs13338873weigh__s
weightiest1743423weightiest
weightily1942463weightily
weighting1744783weighting
weightless1742713weightless
weirded1234513wei_rded
welched16298833welch_ed
welshed14277203welsh_ed
welted103715823we__lted
wenched163910913wench_ed
wetted103717023we__tted
whished17428023whish_ed
whisted144010013whi_sted
whited134814083whi__ted
wigged124413583w_ig_ged
wiggled13299603w_iggled
wight123725573w_ight__
wights133315783w_ight_s
wilted103915713w_i_lted
wished134417513w_ish_ed
wisted104120273w_i_sted
wited94727143w_i__ted
withed134416233w_ith_ed
witted104216813w_i_tted
wriggled14284663wriggled
wright133713513wright__
wrights14318993wright_s
writhed14389623writh_ed

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.470380193.6
2DLD Change Limit1461621257.20020300.3
3Display Results1251250.0502500.0
 (SQL Overall)1786911257.72023146.5
 
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.