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

199 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
weights1440955(None) 
eights103618981_eights
heights14399441heights
weighs13338871weigh_s
weight133914181weight_
weighty17376231weighty
wights133315781w_ights
wrights14318991wrights
alights113211432alights
bedights1544742bedights
bights124417962_bights
blights133110212blights
brights133710232brights
delights1347332delights
dights114016962_dights
eight94928052_eight_
eighth133310602_eighth
eighths14388292_eighths
eighty133711602_eighty
fights133816552_fights
flights143310982flights
freights1555852freights
frights14339622frights
height134713432height_
heighth13366342heighth
heighths14324822heighths
hights133716892_hights
knights1545652knights
lights104519912_lights
mights123516252_mights
neighs10387732neigh_s
nights104117722_nights
plights13299312plights
refights1555882refights
relights1248052relights
resights1246732resights
rights104019332_rights
sights103818012_sights
sleights12275912sleights
slights112810722slights
tights104015852_tights
unweights1643202unweights
waughts14355962waughts
wechts1446252we_chts
weigh125412512weigh__
weighed15135932weighed
weigher14136342weigher
weighers15135672weighers
weighted1635592weighted
weighter1535602weighter
weighters1644672weighters
whishts16425312whishts
wight123725572w_ight_
wright133713512wright_
alight103816863alight_
aright103817663aright_
aughts104710243_aughts
aweigh1334933aweigh__
bedight1437483bedight_
begets96215523be_gets
beiges91014413beig_es
beignes10149243beignes
beignets11155373beignets
beknights1942243beknights
bight118728843_bight_
bigots95015133_bigots
blight124114623blight_
blighty16356843blighty
bright124215923bright_
deigns8389983deig_ns
deists74916433dei_sts
delight12610673delight_
dight104027003_dight_
digits84114533_digits
eighties12710803_eighties
eightvo1443843_eightvo
eightvos1543743_eightvos
ergots74512373_ergots
eyesights1642203eyesights
feigns10407753feig_ns
feints94813873fei_nts
feists94915313fei_sts
fight124027093_fight_
flight134014813flight_
flighty17347433flighty
flyweights2351913flyweights
freight1447603freight_
fright133715243fright_
geishas1135083geishas
gigots83911953_gigots
heigh124812543heigh__
heighten1545703heighten
heightens1644713heightens
heightism1843743heightism
heists96814633hei_sts
heughs13516903heugh_s
highs125412523_high_s
hight125327233_hight_
highth12389153_highth
highths13358003_highths
infights1545573infights
insights1245493insights
knight1438173knight_
laighs10508803laigh_s
legists899593legists
legits71313003le_gits
lengths1144083lengths
lichts113712383_lichts
light94429603_light_
lowlights1643653lowlights
might113827083_might_
mighty154310213_mighty
naughts11447513naughts
neigh94912383neigh__
neighed12135893neighed
nighs95013613_nigh_s
night94327853_night_
nighty135611273_nighty
noughts11478083noughts
oughts104710183_oughts
penlights1544203penlights
plight123513363plight_
refight1488873refight_
reigns74811753reig_ns
relight11512063relight_
resight11510643resight_
reweighs1583203reweigh_s
right94430503_right_
righto104111093_righto
righty135011833_righty
seiches12513813seiches
sennights1343433sennights
sighs95416743_sigh_s
sight94629293_sight_
sleighs11245673sleigh_s
sleight11279023sleight_
slight103416003slight_
spigots1037793spigots
sprights14167143sprights
thighs1346633thigh_s
tight93626503_tight_
tonights1244593tonights
twilights1642533twilights
unsights1244623unsights
unweight1544743unweight_
uplights14165053uplights
uprights14145313uprights
waists97415453wai_sts
waits88333523wai__ts
wauchts15285283wauchts
waught133811043waught_
wealths13365813wealths
wecht13415443we_cht_
wedges114614583wedg_es
wedgies123910213wedgies
weeknights21161523weeknights
weets85427723we__ets
wefts116715493we__fts
weigela1143073weigela
weigelas1243103weigelas
weighing1635283weighing
weighman1742483weighman
weighmen1743463weighmen
weightier1643313weightier
weightiest1743423weightiest
weightily1942463weightily
weighting1744783weighting
weightless1742713weightless
weiners103913063weiners
weirdos11355123weirdos
weirds10478053wei_rds
weirs84316493wei__rs
welches153710313welches
welshes13379093welshes
welts85225193we__lts
wenches152914133wenches
wergelts1253413wergelts
weskits1434743weskits
wests85727003we__sts
wets75940293we___ts
whigs125612643whig__s
whishes16309443whishes
whisht154510813whisht_
whists124613813whi_sts
whits115923823whi__ts
wiches144418753w_iches
widgets12318453widgets
widths1335123w_idths
wigans104511703w_igans
wiglets113411423w_iglets
wigs84931253w_ig__s
wilts85023503w_i_lts
wishes124920953w_ishes
wists86728523w_i_sts
withes124620843w_ithes
wits76044873w_i__ts
wrists95415643wri_sts
writhes134811703writhes
writs86624383wri__ts

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 Filter1786911340270.423422437.4
2DLD Change Limit1340271996.54620474.6
3Display Results1991990.0633158.7
 (SQL Overall)1786911997.03225411.1
 
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.