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

130 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
thinnest1124890(None) 
thinness11277171thinness
shiniest113212502shiniest
tannest72617852t_annest
thickest17337302thickest
thingness1354902thingness
thinned11399172thinne_d
thinner10358982thinne_r
thinners11327762thinners
thinnish1454882thinnish
tiniest73020122t_iniest
tinniest82911462t_inniest
twiniest1147152twiniest
whiniest14298752whiniest
whinniest15245142whinniest
blindest11609093blindest
briniest102812333briniest
chicest14209943chi_cest
chicness1535593chicness
chiefest1645313chiefest
chillest13259593chillest
chines115029173chi_nes_
chinkiest1867023chinkiest
chinless1337493chinless
chinned134810503chinne_d
chinones13510483chinones_
chirkest1735383chirkest
dunnest83312263_dunnest
fainest10417703fai_nest
faintest1139073faintest
finest94321733_fi_nest
finniest113011403_finniest
funnest102912003_funnest
ginniest92610513_ginniest
hangnest12311413_hangnest
highest1439563_highest
hinges105121033_hinges_
hinkiest153311753_hinkiest
hinnies103615113_hinnies_
hipness12277383_hipness
hippest14219763_hippest
honest94822423_h_onest
inanest72115363__inanest
incest82918743__incest
infest93315433__infest
ingest73119003__ingest
invest93014843__invest
kindest12311503_kindest
liniest73321153_liniest
linnet6419423_linne_t
linnets739833_linnets
phoniest132811543phoniest
piniest93121133_piniest
pinkest132812623_pinkest
rainiest81214923rainiest
reinvest1138203reinvest
shiest95821533shi__est
shines95028913shi_nes_
shininess1237343shininess
shinned114310923shinne_d
shinnery14305683shinnery
shinney13368303shinne_y
shinneys14275103shinneys
shinnies113010923shinnies_
skinniest1335523skinniest
spiniest102813233spiniest
tawniest11279343tawniest
teeniest82112413teeniest
tennist72813113t_ennist
tensest72713313t_ensest
thanes94918983th_anes_
theines104013233theines_
thewiest14196343thewiest
thicket163213073thicke_t
thickets17287083thickets
thickness1844443thickness
thickset17257133thickset
thieves1346903thieves_
thine85026863thi_ne__
things104914303thi_ngs_
thinker143610683thinke_r
thinkers15308703thinkers
thinks134613363thi_nks_
thinnesses1346273thinnesses
thinning12319093thinning
thins85826333thi_n_s_
thionines12106973thionines_
thirst9312253thi__rst
thorniest1236483thorniest
thrones105715843thrones_
thymiest1634733thymiest
tidiest83514873t_idiest
tines54848423t_i_nes_
tinges74722343t_inges_
tininess8310633t_ininess
tinned74317533t_inne_d
tinner64119963t_inne_r
tinners73717313t_inners
toniest73218903t_oniest
tonnes65320853t_onnes_
trapnest10310923trapnest
trienes74118413trienes_
triggest1036923triggest
trigness968403trigness
trimmest12227023trimmest
trimness1067563trimness
trines64132563tri_nes_
trinket11314813trinke_t
trinkets1237143trinkets
tritest7315273tri_test
triunes74311383triunes_
twines94717273twi_nes_
twinges11409453twinges_
twinjet1735113twinje_t
twinjets1842413twinjets
twinned11366333twinne_d
twinset1039373twinse_t
twinsets1133663twinsets
vainest10315763vai_nest
vainness1136063vainness
veiniest1139383veiniest
viniest103216613_viniest
wannest103915003_wannest
whines125120103whi_nes_
whinges143610633whinges_
whininess1535133whininess
whinnies14237283whinnies_
whitest133710113whi_test
whitiest14259883whitiest
winiest103419693_winiest

Search took 7 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.406440125.6
2DLD Change Limit1461621306.50022486.5
3Display Results1301300.0632063.5
 (SQL Overall)1786911306.96925640.8
 
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.