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

182 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
faintest113907(None) 
fainest10417701fain_est
daintiest1039152daintiest
fainted114211722fainte_d
fainter103611052fainte_r
fainters11349692fainters
faintish1446192faintish
faintness1235832faintness
faints94818782faint_s_
fairest10412292fai_rest
fantast10311702fa_ntast
fastest102413722fa_stest
fattest102913062fa_ttest
fawniest14287442fawniest
finest94321732f_in_est
fittest102510802f_ittest
flintiest1248432flintiest
gauntest936602gauntest
paintiest11310562paintiest
quaintest1845342quaintest
rainiest81214922rainiest
vainest10315762vain_est
acutest94410603_acutest
airest63825263_ai_rest
airiest74221013_airiest
antes56334323_a_ntes_
aptest82917513_a_ptest
attest62618613_a_ttest
barniest104815053barniest
blindest11609093blindest
bluntest1036553bluntest
brainiest11209723brainiest
briniest102812323briniest
canniest10313363canniest
contest93523233_contest
daftest11248943da_ftest
dainties9312403dainties_
damndest1276003damndest
dankest122611673da_nkest
darndest1067223darndest
earnest7318733earn_est
fabbest1438033fa_bbest
faddiest1338113faddiest
faggiest132910183faggiest
faiences1337043faiences_
failles102914133failles_
faineant1146743faineant
fainer94717243fain_e_r
faint85837063fain___t
fainting123312163fainting
faintly1337083faint_ly
fairies103516043fairies_
fairness1136563fairness
faiths124610273fai_ths_
falsest10310013fa_lsest
famines123216263famin_es_
fanciest133612713fanciest
fanes84639893fa_n_es_
fanjet16311393fa_nje_t
fanjets1734803fa_njets
fannies103415643fannies_
fantasm1236593fa_ntasm
fantasts1147113fa_ntasts
fantasy1336153fa_ntasy
farness102912203farn_ess
farthest1499863farthest
fastness11238763fastness
fates85139233fa__tes_
fatness103311293fatn_ess
fattiest113514313fattiest
faultiest1236093faultiest
featest102715113f_eatest
feinted11379623feinte_d
feints94813873feint_s_
feistiest1237073feistiest
fenniest113113203fenniest
ferniest1132214153ferniest
fiances12310673fiances_
fines86644263f_in_es_
finites10315923f_inites_
finless102810783f_inless
finniest113011403finniest
firmest1239273f_irmest
fitness10299393f_itness
flattest1138713flattest
flauntiest1343773flauntiest
fleetest1136723fleetest
fliest94718433fli__est
flinted114411893flinte_d
flints95617453flint_s_
flippest1535173flippest
flirtiest1236193flirtiest
flites95122443fli_tes_
fondest11312403f_ondest
frailest1139493frai_lest
frankest1536963frankest
fringes113514103fringes_
fringiest1347603fringiest
frites94922483fri_tes_
frontes104214163frontes_
funest94316863f_un_est
funfest13348083f_unfest
funnest102912003f_unnest
funniest113010733funniest
gainless9117403gainless
gainliest1037133gainliest
gainst74914693gain__st
giantess933893giantess
glintiest1037623glintiest
grainiest10188993grainiest
haints94417583haint_s_
hairiest11612463hairiest
incest82918743__incest
infest93315433__infest
ingest73119003__ingest
intent63122773__intent
invest93014843__invest
jauntiest1635493jauntiest
kainites1238793kainites_
kindest12311503_kindest
lankest112714113la_nkest
latest63822703la__test
liniest73321153_liniest
lintiest82715913_lintiest
mainmast1245873mainmast
manifest1339503manifest
mantes84430783ma_ntes_
mintiest103217143_mintiest
minutest10247653_minutest
moistest1038763moistest
naivest10309473nai_vest
painless10108343painless
painted104214633painte_d
painter93814563painte_r
painters103013023painters
paints85921833paint_s_
patientest1245713patientest
piniest93121133_piniest
pinkest132812623_pinkest
plainest10313613plain_est
plaintext1863423plaintext
pointes93216753pointes_
pointiest1139623pointiest
quietest1757173quietest
quintes164114713quintes_
quintet163914453quinte_t
quintets17347203quintets
rainless8129703rainless
rankest112713813ra_nkest
reinvest1138203reinvest
sainted84114243sainte_d
saintliest1046013saintliest
saints65122423saint_s_
saltest71916513sa_ltest
sanest64426693sa_n_est
scantest101710183scantest
shiniest113212493shiniest
spiniest102813223spiniest
squintest1845703squintest
swiftest1434353swiftest
tainted83512423tainte_d
taintless935733taintless
taints64520533taint_s_
tannest72617853ta_nnest
tartest72517533ta_rtest
tautest72612443ta_utest
tawniest11279343tawniest
thinnest11248893thinnest
tiniest73020123_tiniest
tritest7315273tri_test
twiniest1147153twiniest
vainness1136063vainness
vastest102911513va_stest
veiniest1139383veiniest
viniest103216613_viniest
waniest103819113wa_niest
wannest103915003wa_nnest
wattest102412153wa_ttest
whiniest14298753whiniest
whitest133710113whi_test
winiest103419693_winiest
zaniest163214773za_niest

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 Limit1461621826.39022873.6
3Display Results1821820.0632888.9
 (SQL Overall)1786911826.85926052.0
 
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.