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

154 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
clearest103865(None) 
cleanest10310291cleanest
bleakest1436282bleakest
bleariest1158852bleariest
cheapest1536072cheapest
claret84026572cl_are_t
clarets94111102cl_arets
clearcut1244222clearcut
cleared103612462cleare_d
clearer93710822cleare_r
clearers10349302clearers
clearness1135632clearness
clears84116562clear_s_
cleaves124111622cleaves_
cleverest1444502cleverest
dearest83618672_dearest
leanest7415862_leanest
leariest83117852_leariest
nearest73415842_nearest
searest73322022_searest
unclearest12113822unclearest
alcahest1345353alcahest
alertest8310173alertest
alkahest1554023alkahest
almagest1146233almagest
barest85327693__barest
blares85021633bl_ares_
bleared104211253bleare_d
blears85116453blear_s_
cabaret112519043cabare_t
cabarets12268463cabarets
cares77369183c__ares_
caress85720263c__aress
caret75360563c__are_t
carets85330773c__arets
ceases84427073c_eases_
cellaret103713583cellare_t
cellarets11246063cellarets
ceres75540013c_e_res_
chares115631803c_hares_
chariest13315513c_hariest
cheeriest1438213cheeriest
chevres15379793chevres_
chevret153310633chevre_t
chevrets16255323chevrets
chewiest16177293chewiest
cigaret10413003cigare_t
cigarets1145473cigarets
clades94920463cl_ades_
cladist10311973cl_adist
claries93422203cl_aries_
claroes93113743cl_aroes_
claros84015113cl_aros_
clast76030583cl_a__st
claves115020063cl_aves_
clayiest1337923clayiest
cleaned103512003cleane_d
cleaner93712303cleane_r
cleaners103610543cleaners
cleanliest1244363cleanliest
cleanness1144973cleanness
cleans85817053clea_ns_
cleanse9358723clea_nse
cleansed11395933cleansed
cleanser10356323cleanser
cleanses10358143cleanses
clear76219053clear___
clearcuts1341913clearcuts
cleareyed1572113cleareyed
clearing113014883clearing
clearly1236663clear_ly
clearweed1542163clearweed
cleat76335063clea___t
cleated103417853cleate_d
cleats84919313clea_ts_
cleave114212513cleave__
cleaved134010483cleave_d
cleaver124110803cleave_r
cleavers13398873cleavers
clement11313773cle_ment
cleomes1138813cleomes_
clepes104214623cle_pes_
clerisy1246823cle_risy
clerks12458843cle_rks_
closest94312533cl_osest
coarsest1039163c_oarsest
coerect11913353coe_rect
collaret103116703collare_t
collarets11327333collarets
coparent12412253coparent
creakiest15238593creakiest
creamiest13248933creamiest
creases94020963creases_
creasiest11229943creasiest
creates95225203creates_
crepiest12310383crepiest
crest74632693c___rest
curares94916853curares_
czarist18710223c_zarist
deadest93014883_deadest
deafest112911513_deafest
dreariest10229123dreariest
earnest7318733__earnest
featest102715113_featest
flares94521703fl_ares_
fleetest1136723fleetest
glares75518873gl_ares_
glariest92012533gl_ariest
gleamiest1235313gleamiest
greatest939863greatest
headrest122910203_headrest
lamest84722763_l_amest
lares54852633_l_ares_
largest83715103_l_argest
latest63822703_l_atest
laxest134913363_l_axest
leadiest93314993_leadiest
leafiest113410893_leafiest
leakiest123212803_leakiest
learns65513743_learns_
learnt64019253_lear_nt
lears55938733_lear_s_
leases65428113_leases_
least56134883_lea__st
leaves94222383_leaves_
leaviest112910823_leaviest
leeriest83112883_leeriest
leftest10269463_leftest
lewdest1136283_lewdest
meanest9315703_meanest
merest84725113_me_rest
neatest72516003_neatest
oleates7417833oleates_
peartest10311303_peartest
pleases94515483pleases_
queerest1746273queerest
rarest65725483__rarest
realest73322433_realest
rearrest8311603_rearrest
serest64831613_se_rest
sheerest11310083sheerest
sleaves103813203sleaves_
sleazes162810333sleazes_
sleaziest1836063sleaziest
sleekest1236153sleekest
smeariest1138123smeariest
sparest94616433_sparest
squarest17338223squarest
teariest82417263_teariest
uncleanest12105663uncleanest
vulgarest1343773vulgarest
weakest1439003_weakest
weariest112914793_weariest
yarest95018913__yarest

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.423422437.4
2DLD Change Limit1461621546.61022112.3
3Display Results1541540.0632444.4
 (SQL Overall)1786911547.09625181.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.