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

298 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
naivest1030947(None) 
naives94914221naives_
airest63825262_airest
divest106820072_divest
fainest10417702fainest
fairest10412292fairest
harvest132112752harvest
livest95315732_livest
nailset7311972nailset
naive85116212naive__
naively1335902naively
naiver94311352naive_r
naivete1055662naivete
naivety1344272naivety
natives10310822natives_
nativist11118672nativist
naves87030382na_ves_
navies95218622navies_
nicest82315662n_icest
vainest10315762vainest
waives123714182waives_
waviest134513072waviest
ablest84721833_ablest
advect12309123_advect
advent102613753_advent
advert103215773_advert
aides65336603_aides_
airiest74221013_airiest
aiver85725163_aive_r
aivers94822323_aivers
anapaest1046023anapaest
anapest9311553anapest
animes84719593animes_
animist93815173animist
anises64826693anises_
aptest82917513_aptest
aridest8316143aridest
arrest63722633_arrest
attest62618613_attest
avast85519363_a_vast
avert86029493_a_vert
aves76142603_a_ves_
babiest114414753babiest
baddest112611143baddest
baizes174315053baizes_
baldest102313533baldest
barest85327693ba_rest
basest84720493ba_sest
bravest124211753bravest
cagiest102916433cagiest
cakiest133215663cakiest
calmest11312343calmest
calves115119283calves_
carves115128453carves_
caveat11417723ca_veat
caves105639703ca_ves_
cavies114525003cavies_
chicest14209943chicest
chives144317593chives_
civet105828733_cive_t
civets115212543_civets
daftest11248943daftest
daises74318983daises_
dampest12411043dampest
dankest122611673dankest
darkest122512623darkest
datives11310073datives_
davies105020513davies_
devest104418703_devest
digest84019623_digest
direst75024243_direst
divert103922813_divert
dives95832403_dives_
divests114510933_divests
driest74722753dri_est
drives105117113drives_
earnest7318733earnest
easiest72318773easiest
eaves85231993ea_ves_
endives113710693endives_
evilest10310473evilest
fabbest1438033fabbest
faintest1139073faintest
falsest10310013falsest
fastest102413723fastest
fattest102913063fattest
fauves125610423fauves_
fauvist1336663fauvist
faves115331423fa_ves_
finest94321733_finest
fives116027363_fives_
fliest94718423fli_est
frailest1139493frailest
gabfest1336453gabfest
gainst74914693gai_nst
gamest94919923ga_mest
gamiest102816223gamiest
gashest114813413gashest
gayest104314333ga_yest
gives95324873_gives_
glaives11347833glaives_
gravest114011633gravest
grivet103517823grive_t
grivets11357973grivets
haddest122711993haddest
hairiest11612463hairiest
halest94823273ha_lest
halves124717093halves_
hardest113118413hardest
harvests14246173harvests
haves116034873ha_ves_
haziest193313003haziest
heaviest143210443heaviest
hives116925513_hives_
iciest82914743ici_est
inanest72115363ina_nest
inkiest113415043inki_est
invest93014843_invest
jives154820813_jives_
jiviest1738113_jiviest
knaves13439523kna_ves_
knives13458553knives_
laciest93819033laciest
lakiest113517263lakiest
lamest84722763la_mest
lankest112714113lankest
largest83715103largest
latest63822703la_test
laves86039153la_ves_
laxest134913363la_xest
laziest163814473laziest
leaviest112910813leaviest
lievest1048343lievest
likest104914383_likest
lives86133193_lives_
maddest112311213maddest
mailes84329113mailes_
maist75535673mai__st
maizes175115733maizes_
manifest1339503manifest
matiest92522453matiest
mauves113811553mauves_
mavies114923193mavies_
mayest114614793ma_yest
maziest183613873maziest
nabes75427093na_bes_
naches114622413naches_
nacres85614453nacres_
naevus934593naevus_
naggiest102610013naggiest
naiades838213naiades_
naiads739013naiads_
naifs87617423nai_fs_
nailed74021493naile_d
nailer64119363naile_r
nailers73215893nailers
nails55730403nai_ls_
nailsets834553nailsets
nairas6312773nairas_
nairus639143nairus_
naiveness1277483naiveness
naivetes1145113naivetes
nakedest1345473nakedest
names74833363na_mes_
nances83618643nances_
napes74828463na_pes_
napless93110283napless
nappes104515623nappes_
nappiest122510883nappiest
narcist9512433narcist
nares55544153na_res_
nascent9610523nascent
nastiest83615953nastiest
nates55238333na_tes_
native9613013native__
natively1446413natively
nativism13116613nativism
nativists12116243nativists
nattiest83215353nattiest
nave75732313na_ve__
navel87016573na_ve_l
navels95712693na_vels
navette1036983na_vette
navicert1344883navicert
navvies1335323navvies_
nearest73415843nearest
neatest72516003neatest
neist54628443nei__st
nerves94216193nerves_
nerviest11188833nerviest
nest45548733n___est
neves87021873n_eves_
newest9314213n_ewest
nides65229133n_ides_
nieves94311293nieves_
nighest11310693nighest
nines55937343n_ines_
nites55736343n_ites_
nixes124519623n_ixes_
noblest93613563noblest
noises65021853noises_
noisiest839763noisiest
nosiest73415673nosiest
nudest74113833n_udest
numbest1138793numbest
oakiest112913923oakiest
oaves84925613oa_ves_
ogives10367913ogives_
olives94313953olives_
paciest112917803paciest
palest83926223pa_lest
paliest93021603paliest
paves104833923pa_ves_
plainest10313613plainest
priest84125423pri_est
privet113821343prive_t
privets122910053privets
priviest132310313priviest
raciest92820013raciest
raiment9315413raiment
rainiest81214923rainiest
raises64826543raises_
rankest112713813rankest
rapidest1138543rapidest
rarest65725483ra_rest
rashest103916873rashest
raves85441973ra_ves_
rawest93615063ra_west
reinvest1138203reinvest
reives95723043reives_
revest94623603_revest
rifest93114583_rifest
ripest84317933_ripest
rives85336003_rives_
rivet85636363_rive_t
rivets94417113_rivets
saddest92412383saddest
safest95016603sa_fest
sagest74920263sa_gest
sagiest82617983sagiest
saices84221803saices_
saltest71916513saltest
salves94221763salves_
sanest64426693sa_nest
saves85838633sa_ves_
savviest1435983savviest
sayest94217743sa_yest
shiest95821523shi_est
shives124921413shives_
skives134113943skives_
sliest66621943sli_est
snakiest122110533snakiest
snidest8310913snidest
staidest939803staidest
suavest10310623suavest
swives123915183swives_
swivet123615473swive_t
swivets13436963swivets
tallest7317093tallest
tamest85721293ta_mest
tannest72617853tannest
tartest72517533tartest
tautest72612443tautest
tritest7315273tritest
trivet93721883trive_t
trivets103911583trivets
unfairest1243563unfairest
unlives102010953unlives_
unripest1046083unripest
unwisest1165123unwisest
vaguest1137333vaguest
valves124113783valves_
varves124414783varves_
vastest102911513vastest
vest75743603___vest
vilest9416843_vilest
wackest164710863wackest
waist86132383wai__st
waive114214603waive__
waived134511283waive_d
waiver124212713waive_r
waivers133410053waivers
waniest103819113waniest
wannest103915003wannest
wariest105122503wariest
warmest123113033warmest
wattest102412153wattest
waves115633923wa_ves_
wavies125019843wavies_
waxiest173510883waxiest
whitest133710113whitest
widest104517003_widest
wisest95016443_wisest
wives115328923_wives_
wriest94419713wri_est
yarest95018913ya_rest
zaires1539703zaires_
zaniest163214773zaniest

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340272987.79617191.8
3Display Results2982980.0933204.3
 (SQL Overall)1786912988.04522211.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.