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

104 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
tightest1214836(None) 
lightest121410351lightest
rightest12149581rightest
brightest1545662brightest
highest1439562high_est
mightiest1546442mightiest
nighest11310692nigh_est
rightist12159142rightist
slightest13136942slightest
tighten11288972tighte_n
tightens12297952tightens
tighter112910692tighte_r
tightness1386602tightness
tights104015852tight_s_
biggest1138143big_gest
bighted142810923bighte_d
bights124417963bight_s_
digest84019623dig__est
dighted132511493dighte_d
dights114016963dight_s_
dishiest12313683dishiest
eighteen1245763eighteen
eighths14388293eighths_
eighties12710803eighties_
eights103618983eight_s_
fighter143010773fighte_r
fighters15269403fighters
fights133816553fight_s_
fishiest14310453fishiest
fittest102510803fi_ttest
flightiest1744503flightiest
highness1536053highness
highted152710163highte_d
highths13358003highths_
hights133716893hight_s_
iratest7312483_iratest
itchiest1336523itchiest
jiggiest17277693jiggiest
ligates82318383ligates_
lighted122913503lighte_d
lighten112811523lighte_n
lightens122510003lightens
lighter113113443lighte_r
lighters123111393lighters
lightfast1643643lightfast
lightish1556623lightish
lightless1386073lightless
lightness13107433lightness
lights104519913light_s_
lithest10513913lith_est
mights123516253might_s_
minutest10247653minutest
nighness1236103nighness
nighties121011383nighties_
nightless1386073nightless
nights104117723night_s_
piggiest12259663piggiest
pithiest132711443pithiest
richest122813683rich_est
righted122912143righte_d
righter113212383righte_r
righters122610713righters
righties12711573righties_
rightism14156963rightism
rightists13126053rightists
rightmost1544053rightmost
rightness13117353rightness
rights104019333right_s_
sighless1276553sighless
sighted123111523sighte_d
sighter113412113sighte_r
sighters122510603sighters
sightless1385923sightless
sightliest1445103sightliest
sights103818013sight_s_
sightsee1245473sightsee
straightest1564343straightest
tartest72517533t_artest
tautest72612443t_autest
techiest1359833techiest
tidiest83514873ti_diest
tight93626503tigh___t
tightened1444963tightened
tightener1344703tightener
tightknit1752573tightknit
tightly14327613tight_ly
tightwad1642903tightwad
tigress836093tig_ress
timidest1136933timidest
tingliest1047683tingliest
tiniest73020123ti_niest
tinniest82911463tinniest
tippiest122310013tippiest
tipsiest10228953tipsiest
tiredest938403tiredest
tithes94720213tith_es_
toughest1238303tough_est
triggest1036923trig_gest
tritest7315273t_ritest
twiggiest1443413twiggiest
weightiest1743423weightiest
wiggiest13269013wiggiest
wights133315783wight_s_
withiest142411243withiest

Search took 9 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.403443402.0
2DLD Change Limit1461621048.14317949.4
3Display Results1041040.0462260.9
 (SQL Overall)1786911048.59220797.4
 
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.