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 “weightier” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

55 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
weightier164331(None) 
weighter1535601weight_er
eighties12710802_eighties
flightier1644422flightier
mightier1436382_mightier
weigher14136342weigh__er
weighted1635592weight_ed
weighters1644672weight_ers
weightiest1743422weightiest
weightily1942462weightily
weighting1744782weighting
blighter1466853blight_er
blighties1546223blighties
brighter1476663bright_er
delighter1445583delight_er
doughtier1443463doughtier
eighteen1245763_eighteen
eightieth1643093_eightieth
feistier1136193fei_stier
fighter143010773_fight_er
freighter1655023freight_er
haughtier1642743haughtier
heighten1545703height_en
heightism1843743heightism
lengthier1342413lengthier
lighter113113443_light_er
naughtier1343103naughtier
nightie1179653_nightie_
nighties121011383_nighties
plighter1476623plight_er
righter113212383_right_er
righties12711573_righties
sighter113412113_sight_er
sightlier1344453_sightlier
slighter1257823slight_er
tighter112910693_tight_er
wealthier1543263wealthier
wedgier12428283wedg__ier
weighed15135933weigh__ed
weighers15135673weigh__ers
weighing1635283weigh_ing
weighmen1743463weigh_men
weight133914183weight___
weightiness1843263weightiness
weightless1742713weightless
weights14409553weight__s
weighty17376233weight__y
whitier133311063whi__tier
wiftier13297733w_i_ftier
wiggier12418863w_ig_gier
wigglier1354453w_igglier
withier132910493w_ith_ier
wittier103910823w_i_ttier
wrigglier1462413wrigglier
wristier1136863wri_stier

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 Filter1786911486410.436409841.7
2DLD Change Limit148641557.25020502.2
3Display Results55550.0301833.3
 (SQL Overall)178691557.71623158.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.