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

422 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
vainest1031576(None) 
fainest10417701fainest
airest63825262_airest
earnest7318732earnest
faintest1139072faintest
fairest10412292fairest
finest94321732_finest
gainst74914692gain_st
naivest10309472naivest
plainest10313612plainest
rainiest81214922rainiest
sanest64426692sa_nest
tannest72617852tannest
vaguest1137332vaguest
vahines133410522vahines_
vainer93714572vaine_r
vainness1136062vainness
valines104520212valines_
vanes85130972va_nes_
vastest102911512vastest
veiniest1139382veiniest
vilest9416842v_ilest
vines85137642v_ines_
viniest103216612v_iniest
waniest103819112waniest
wannest103915002wannest
zaniest163214772zaniest
ablest84721833_ablest
acnes75922623_acnes_
against838383again_st
aides65336603_aides_
ains46158883_ain_s_
airiest74221013_airiest
alines65735223alines_
amines84727983amines_
amnesty1244823_amnesty
anenst63514983_a_nenst
anent54931843_a_nent
anes45255933_a_nes_
angst6415493_a_ngst
aptest82917513_aptest
aridest8316143aridest
arrest63722633_arrest
attest62618613_attest
avidness1246113avidness
azines155517073azines_
babiest114414753babiest
baddest112611143baddest
badness1039573badness
baizes174315053baizes_
baldest102313533baldest
banes74945583ba_nes_
bannet84925333banne_t
bannets94013843bannets
barest85327693ba_rest
barniest104815053barniest
basest84720493ba_sest
basinet9318933basine_t
basinets1039063basinets
bines76946793_bines_
blindest11609093blindest
boniest93318993boniest
brainiest11209723brainiest
brines85028853brines_
briniest102812323briniest
cabinet11318903cabine_t
cabinets1238283cabinets
cagiest102916433cagiest
caginess11310303caginess
cains75334303cain_s_
cakiest133215663cakiest
cakiness1449553cakiness
calmest11312343calmest
canes75350373ca_nes_
canines93724033canines_
canniest10313363canniest
canst74932213ca_n_st
carnet84732873carne_t
carnets93918403carnets
chaines124518733chaines_
chicest14209943chicest
chines115029173chines_
cineast9310523_cineast
cines75239683_cines_
clines84926043clines_
daftest11248943daftest
daintiest1039153daintiest
daises74318983daises_
damndest1276003damndest
dampest12411043dampest
dankest122611673dankest
darkest122512623darkest
darndest1067223darndest
digest84019623_digest
dines66449153_dines_
direst75024243_direst
divest106820073_divest
divinest123012173divinest
driest74722753dri_est
dunnest83312263dunnest
dwines105013103dwines_
earnests837853earnests
easiest72318773easiest
easiness8313043easiness
eminent9313843eminent
evenest10312103evenest
evilest10310473evilest
exines135715803exines_
fabbest1438033fabbest
faineant1146743faineant
fainer94717243faine_r
faint85837063fain__t
faints94818783faints_
fairness1136563fairness
falsest10310013falsest
famines123216263famines_
fanes84639893fa_nes_
farness102912203farness
fastest102413723fastest
fatness103311293fatness
fattest102913063fattest
fawniest14287443fawniest
fines86644263_fines_
fliest94718433fli_est
frailest1139493frailest
funest94316863_funest
funnest102912003funnest
gabfest1336453gabfest
gained84617463gaine_d
gainer74117493gaine_r
gainers84214593gainers
gainless9117403gainless
gainliest1037133gainliest
gains65729513gain_s_
gamest94919923ga_mest
gamiest102816223gamiest
gamines103618463gamines_
gaminess112911063gaminess
gannet74321853ganne_t
gannets83811443gannets
garnet73928413garne_t
garnets84115403garnets
gashest114813413gashest
gauntest936603gauntest
gayest104314333ga_yest
gayness1136843gayness
grainiest10188993grainiest
haddest122711993haddest
haint85436323hain__t
haints94417583haints_
hairiest11612463hairiest
hairnet10911703hairne_t
hairnets1195633hairnets
halest94823273ha_lest
hangnest12311413hangnest
hardest113118413hardest
harness102413933harness
harvest132112753harvest
haziest193313003haziest
haziness20248513haziness
honest94822423_honest
iciest82914743ici_est
iciness938863iciness
imines84918353imines_
inanest72115363inanest
incest82918743__incest
inept73622153__inept
inert53234373__inert
infest93315433__infest
ingest73119003__ingest
inset54430863__inset
invest93014843__invest
janes124928123ja_nes_
kainit10414483kain_it
kainits1137763kainits
kains96125643kain_s_
kanes95529373ka_nes_
keenest11410963keenest
kindest12311503_kindest
kines95039133_kines_
koines10415733koines_
laciest93819033laciest
laciness102112553laciness
lakiest113517263lakiest
lamest84722763la_mest
lanes54946793la_nes_
lankest112714113lankest
largest83715103largest
latest63822703la_test
lawines103313563lawines_
laxest134913363la_xest
laxness1436043laxness
laziest163814473laziest
laziness17239983laziness
leanest7415863leanest
lianes63819323lianes_
likest104914383_likest
lines57054573_lines_
liniest73321153_liniest
livest95315733_livest
luniest73516993luniest
maddest112311213maddest
madness10310073madness
magnet9320663magne_t
magnets10311143magnets
mailes84329113mailes_
mainmast1245873mainmast
mains75635113main_s_
maist75535683mai__st
maizes175115733maizes_
malines93625603malines_
manes76648963ma_nes_
manifest1339503manifest
marines93928013marines_
matiest92522453matiest
matiness102114753matiness
mayest114614793ma_yest
maziest183613873maziest
maziness19239543maziness
meanest9315703meanest
mines75651953_mines_
nailset7311973nailset
naives94914223naives_
nest45548733___nest
nicest82315663_nicest
nines55937343_nines_
oakiest112913923oakiest
openest9312913openest
opines84820703opines_
ovalness1134673ovalness
ovines94614343ovines_
paciest112917803paciest
pained95622853paine_d
painless10108343painless
pains75138283pain_s_
paint75443693pain__t
paintiest11310563paintiest
paints85921833paints_
palest83926223pa_lest
paliest93021603paliest
panes76148693pa_nes_
pannes85522853pannes_
patines95225763patines_
patness92912283patness
pianist9615103pianist
pines76048863_pines_
piniest93121133_piniest
pinkest132812623_pinkest
priest84125423pri_est
puniest92918093puniest
quaintest1845343quaintest
raciest92820013raciest
raciness102413453raciness
raiment9315413raiment
rained75024603raine_d
rainless8129703rainless
rainout7314393rainout
rains55140233rain_s_
raises64826543raises_
rankest112713813rankest
rapidest1138543rapidest
rapines95120863rapines_
rarest65725483ra_rest
rashest103916873rashest
ratines75328583ratines_
ravines104220233ravines_
rawest93615063ra_west
rawness1038153rawness
reinvest1138203reinvest
renest64529713_renest
rifest93114583_rifest
ripest84317943_ripest
sabines94318483sabines_
saddest92412383saddest
sadness8310613sadness
safest95016603sa_fest
sagest74920263sa_gest
sagiest82617983sagiest
saices84221803saices_
sained75424243saine_d
sains55639973sain_s_
saint55147073sain__t
saints65122423saints_
salines74029413salines_
saltest71916513saltest
sanes55649073sa_nes_
sanies63031953sanies_
satinet7325283satine_t
satinets8311733satinets
savines104417633savines_
sayest94217743sa_yest
seines65029903seines_
shiest95821523shi_est
shines95028913shines_
shiniest113212493shiniest
sines55954823_sines_
sliest66621953sli_est
snidest8310913snidest
soonest7415593soonest
spines85132033spines_
spinet85629753spine_t
spinets94714813spinets
spiniest102813223spiniest
staidest939803staidest
tains54936323tain_s_
taint55542283tain__t
taints64520533taints_
tallest7317093tallest
tamest85721293ta_mest
tanist6324593ta_nist
tartest72517533tartest
tautest72612443tautest
tawniest11279343tawniest
thinnest11248893thinnest
tines54848423_tines_
tiniest73020123_tiniest
toniest73218903toniest
trapnest10310923trapnest
trines64132563trines_
tritest7315273tritest
twines94717273twines_
twiniest1147153twiniest
twinset1039373twinset
urines64724123urines_
vaccines1536503vaccines_
vaginas11298813vaginas_
vahine123612113vahine__
vailed104619293vaile_d
vails85825933vai_ls_
vain75233003vain___
vainly1258503vain_ly
vairs85019133vai_rs_
vales85434263va_les_
valet84337873va_le_t
valets93715623va_lets
validness13125363validness
valine94623093valine__
valises103516263valises_
valses94514613valses_
values94314943values_
valves124113783valves_
vampiest15237643vampiest
vane75534693va_ne__
vaned94622423va_ne_d
vangs96319583va_ngs_
vanish121513213va_nish
vanned104614483vanne_d
vanner94215843vanne_r
vanners103612843vanners
vans76236733va_n_s_
vapidness15144423vapidness
varices123313573varices_
varies94330873varies_
varlet9423503varle_t
varlets10411573varlets
varment12313243varment
varnas94212823varnas_
varnish13169533varnish
varves124414783varves_
vases84626263va_ses_
vast75045123va___st
vastiest112713073vastiest
vastness11257293vastness
vaunt85925313vaun__t
vaunts95212623vaunts_
vealiest112513203vealiest
veined104413913veine_d
veiner94514753veine_r
veiners104112523veiners
veinless11136263veinless
veinlet101310573veinlet
veinlets11144833veinlets
veins84620493vein_s_
venines103516613venines_
veriest103719133veriest
vest75743603v___est
viands1047813viands_
vibes104719953v_ibes_
vibist11610583v_ibist
vices105725533v_ices_
vies75238623v_i_es_
vinas85126343v_inas_
vine75643683v_ine__
vineal94814743v_ineal
vined95626153v_ine_d
vinery124912603v_inery
vinos84723073v_inos_
vires84529683v_ires_
vises84427773v_ises_
vividest1545203vividest
voices114414013voices_
voidness1235553voidness
voiles94616443voiles_
wackest164710863wackest
waeness102512783waeness
wahines133111173wahines_
wains86930873wain_s_
waist86132383wai__st
waives123714183waives_
wanes85040883wa_nes_
wanness102610683wanness
wariest105122503wariest
wariness11313213wariness
warmest123113033warmest
wattest102412153wattest
waviest134513073waviest
waviness1437723waviness
waxiest173510883waxiest
waxiness1836723waxiness
whines125120103whines_
whiniest14298753whiniest
whitest133710113whitest
widest104517003_widest
wines85546863_wines_
winiest103419693_winiest
wisest95016443_wisest
wriest94419713wri_est
yarest95018913ya_rest
zaires1539703zaires_
zanies153219673zanies_
zaniness1738663zaniness
zines145232653_zines_

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340274226.89019452.4
3Display Results4224220.1403014.3
 (SQL Overall)1786914227.18624866.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.