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

132 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
weighter153560(None) 
weigher14136341weigh_er
weighted1635591weighted
weighters1644671weighters
weightier1643311weightier
blighter1466852blighter
brighter1476662brighter
delighter1445582delighter
fighter143010772_fighter
freighter1655022freighter
heighten1545702heighten
lighter113113442_lighter
plighter1476622plighter
righter113212382_righter
sighter113412112_sighter
slighter1257822slighter
tighter112910692_tighter
weighed15135932weigh_ed
weighers15135672weigh_ers
weighmen1743462weighmen
weight133914182weight__
weights14409552weight_s
weighty17376232weight_y
alighted1347673alighted
bedighted1744583bedighted
benighted1644743benighted
bighted142810923_bighted
blighted1546863blighted
blighters1555743blighters
brighten1466243brighten
daughter1344503daughter
delighted1546203delighted
delighters1544363delighters
dighted132511493_dighted
eight94928053_eight__
eighteen1245763_eighteen
eighth133310603_eight_h
eighths14388293_eighths
eighties12710803_eighties
eights103618983_eight_s
eightvo1443843_eightvo
eighty133711603_eight_y
either94517423_eith_er
feigner1135593feig_ner
fighters15269403_fighters
flichter1664963flichter
flighted1646973flighted
flightier1644423flightier
freighted1755203freighted
freighters1764123freighters
frighted1657173frighted
frighten1566443frighten
height134713433height__
heightens1644713heightens
heighth13366343height_h
heighths14324823heighths
heights14399443height_s
heister103613623hei_ster
higher134610893_high_er
highted152710163_highted
infighter1644273infighter
keister113011573kei_ster
knighted1745123knighted
laughter1245113laughter
leister73212753lei_ster
lighted122913503_lighted
lighten112811523_lighten
lighters123111393_lighters
meister93114163mei_ster
mightier1436383_mightier
negater83711963ne_gater
neighbor1442243neighbor
neighed12135893neigh_ed
neither1037573neith_er
nigher103612753_nigh_er
plighted1546463plighted
plighters1545533plighters
register939553register
reinter73116843rei_nter
relighted1436863relighted
resighted1436523resighted
retighten1374773retighten
righted122912143_righted
righters122610713_righters
sigher103813703_sigh_er
sighted123111523_sighted
sighters122510603_sighters
sleigher1234313sleigh_er
slighted1357393slighted
slighters1346713slighters
tighten11288973_tighten
unweighted1843153unweighted
waister103812383wai_ster
waiter94321253wai__ter
waughted1643483waughted
weather133513223weath_er
webster1236093we_bster
wedgier12428273wedg_ier
weigh125412513weigh___
weighing1635283weighing
weighman1742483weighman
weighs13338873weigh__s
weightiest1743423weightiest
weightily1942463weightily
weighting1744783weighting
weightless1742713weightless
weiner94214133wei__ner
weirder1144923wei_rder
welcher15319393welch_er
welsher13377443welsh_er
welter93417383we__lter
wencher153811133wench_er
wester94222893we__ster
wether123315393we_th_er
wetter93919443we__tter
whishted1843153whishted
whiter124316393whi__ter
whither163510253whith_er
whitter139110893whi_tter
wiggier12418863w_iggier
wiggler123110763w_iggler
wight123725573w_ight__
wights133315783w_ight_s
winter94222803w_i_nter
wisher123617063w_ish_er
wither124321353w_ith_er
withier132910493w_ithier
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.1561145455.1
2DLD Change Limit1461621327.61019206.6
3Display Results1321320.0632095.2
 (SQL Overall)1786911327.82922824.2
 
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.