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

491 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
harvest13211275(None) 
hardest113118411hardest
harvests14246171harvests
arrest63722632_arrest
barest85327692bar_est
bravest124211752bravest
carves115128452carves_
chariest13315512chariest
darkest122512622darkest
earnest7318732earnest
gravest114011632gravest
haddest122711992haddest
hairiest11612472hairiest
halest94823272ha_lest
halves124717092halves_
hardiest123416342hardiest
hardset113415832hardset
hares86255542har_es_
harness102413932harness
harpist12312362harpist
harshest14310192harshest
harvested1644092harvested
harvester1544332harvester
haves116034872ha_ves_
haziest193313012haziest
hoariest11312882hoariest
hoarsest1137132hoarsest
largest83715102largest
naivest10309472naivest
rarest65725482rar_est
sharpest1339152sharpest
tartest72517532tartest
varves124414782varves_
wariest105122502wariest
warmest123113032warmest
wharves16457142wharves_
yarest95018912yar_est
ablest84721833_ablest
advect12309123_advect
advent102613753_advent
advert103215783_advert
aeriest73924053aeriest
airest63825263_airest
airiest74221013airiest
aptest82917513_aptest
ardent73022613_ardent
ares45871023_ar_es_
argent74023663_argent
aridest8316143_aridest
arles56735743_arles_
armet76739453_arme_t
armets84918353_armets
armrest9310163_armrest
arpent84822093_arpent
arrests73312683_arrests
arses55733873_arses_
artiest73121993_artiest
artist64125543_artist
arvos86015663_arvos_
attest62618613_attest
avast85519363_a_vast
avert86029493_a_vert
aves76142603_a_ves_
babiest114414753babiest
baddest112611143baddest
baldest102313533baldest
barbes104526233barbes_
barbet104427883barbe_t
barbets114915843barbets
bardes95026933bardes_
bares75457133bar_es_
barges94528253barges_
barghest1447913barghest
barguest1137163barguest
barkiest144115153barkiest
barless94317003barless
barmiest125212783barmiest
barniest104815053barniest
barres84427553barres_
barret84930493barre_t
barrets94917103barrets
baryes116218503baryes_
basest84720493ba_sest
braves115524083braves_
brawest123810483brawest
cagiest102916433cagiest
cakiest133215663cakiest
calmest11312343calmest
calves115119283calves_
cares77369183car_es_
caress85720263car_ess
caret75360563car_e_t
carets85330773car_ets
caries85147623caries_
carles85435083carles_
carless95118493carless
carnet84732873carne_t
carnets93918403carnets
carpet104530093carpe_t
carpets113915333carpets
carses85233653carses_
cartes86239473cartes_
carve106227753carve__
carved124320853carve_d
carvel114817573carve_l
carvels124914593carvels
carven114716663carve_n
carver114420153carve_r
carvers124817543carvers
caveat11417723ca_veat
caves105639703ca_ves_
chares115631803char_es_
charges134615983charges_
charriest1438263charriest
chartist131112133chartist
chastest1349703chastest
chirkest1735383chirkest
coarsest1039163coarsest
corves115122523corves_
corvet114626933corve_t
corvets124715023corvets
craves115825393craves_
crest74632693_cr_est
curtest9713963curtest
curves114619283curves_
curvet114720243curve_t
curvets12399913curvets
curviest13309673curviest
daftest11248943daftest
dampest12411043dampest
dankest122611673dankest
dares66146703dar_es_
darndest1067223darndest
dearest83618673dear_est
devest104418703_devest
direst75024243dir_est
divest106820073_divest
drest65530343_dr_est
driest74722753_driest
dryest104811123_dryest
dwarfest1543473dwarfest
dwarves1434463dwarves_
earless74316073earless
earliest82415243earliest
earnests837853earnests
easiest72318773easiest
eaves85231993ea_ves_
eeriest73620673eeriest
fabbest1438033fabbest
fainest10417703fainest
fairest10412293fairest
falsest10310013falsest
farces115223323farces_
fares85852873far_es_
farles96025783farles_
farness102912203farness
farthest1499863farthest
fastest102413723fastest
fattest102913063fattest
fauves125610423fauves_
fauvist1336663fauvist
faves115331423fa_ves_
fervent13310063fervent
firmest1239273firmest
forest94926743for_est
freest95318283_freest
gabfest1336453gabfest
gamest94919933ga_mest
gamiest102816233gamiest
garget84327273garge_t
gargets94614573gargets
garment10315233garment
garnet73928413garne_t
garnets84115413garnets
garret74426563garre_t
garrets84413623garrets
garvey13127873garve_y
garveys14124463garveys
gashest114813413gashest
gayest104314333ga_yest
glariest92012533glariest
goriest82218743goriest
graves104624003graves_
grayest11489363grayest
hades96035113ha_des_
hadjes175210403hadjes_
hadst93220223ha__dst
haeres94017033haeres_
haes77651023ha__es_
haet75659503ha__e_t
haets86525123ha__ets
haffet15311703haffe_t
haffets1636053haffets
hairless1157413hairless
hairnet10911703hairne_t
hairnets1195633hairnets
hajes155420943ha_jes_
hajjes15485243hajjes_
hakes126034303ha_kes_
halbert12314503halbert
hales85449843ha_les_
haloes94623863haloes_
halvas124714173halvas_
halve114818923halve__
halved134813903halve_d
halvers133311423halvers
hames106138703ha_mes_
hamlet113722793hamle_t
hamlets123211403hamlets
hammiest152610013hammiest
hances115621283hances_
handiest123417783handiest
handset113016823handset
hangnest12311413hangnest
hanses95022633hanses_
haoles94919803haoles_
hapless123311333hapless
happiest152411683happiest
harass9313943har_ass
hardass1139753hardass
harden105718533harde_n
hardens113815023hardens
harder105022403harde_r
hardhat14411023hardhat
hardies114923233hardies_
hardness122411083hardness
hards96435653har_ds_
hare76255733har_e__
hared95742183har_e_d
hareem114312063har_eem
hareems12428203hareems
harem104924453har_e_m
harems115513823har_ems
haricot12311963haricot
harissa1035503harissa
harked145422553harke_d
harken135116343harke_n
harkens144112863harkens
harks126333433har_ks_
harlot94422803har_lot
harlots103413293harlots
harls85634503har_ls_
harmed125218833harme_d
harmer114719553harme_r
harmers124116593harmers
harmless1337403harmless
harms106829013har_ms_
harped124418403harpe_d
harper115018403harpe_r
harpers124916203harpers
harpies123818323harpies_
harpists1338103harpists
harps105926873har_ps_
harries103525503harries_
harsh116418053har__sh
harslet10315653harslet
harslets1137833harslets
hart76865773har___t
harts88441593har_ts_
harvesters1644153harvesters
harvesting1744413harvesting
harvestman1851323harvestman
harvestmen1852343harvestmen
hashes125024803hashes_
haslet93222713hasle_t
haslets102510863haslets
hast76259483ha___st
hastes95727073hastes_
hastiest112916503hastiest
hates86742573ha_tes_
hatless103813443hatless
have106137073ha_ve__
haven114718533ha_ve_n
havens124514043ha_vens
haver115124463ha_ve_r
havers124721483ha_vers
hawses125113993hawses_
hazes174928323ha_zes_
headiest123015553headiest
headrest122910203headrest
hearses104414543hearses_
heartiest12311103heartiest
heaves124120303heaves_
heaviest143210443heaviest
helves124316063helves_
heppest14228153heppest
herbiest1339993herbiest
hereat93527413her_eat
heres86245903her_es_
heresy125011233her_esy
heroes94923833heroes_
herpes115517323herpes_
hest75950773h___est
highest1439563highest
hippest14219763hippest
hirees95117293hirees_
hires86134343hir_es_
hives116925513h_ives_
hokiest144114243hokiest
holiest104319623holiest
homiest124116633homiest
honest94822423h_onest
hooves124815493hooves_
hordes104921633hordes_
hornet94926433horne_t
hornets104113553hornets
horniest112814043horniest
hornist102314823hornist
horrent10313553horrent
horses94729353horses_
horsiest112513263horsiest
horst85833513hor__st
hottest10411383hottest
hugest10311763h_ugest
hurst85527193hur__st
invest93014843_invest
iratest7312483iratest
jarvey19135403jarve_y
jarveys20123413jarveys
karst97228993kar__st
laciest93819043laciest
lakiest113517273lakiest
lamest84722763la_mest
lankest112714113lankest
lardiest93813893lardiest
larees65323113larees_
lares54852633lar_es_
larges74824233larges_
largess8408913largess
larkiest123713323larkiest
larvas9310233larvas_
latest63822703la_test
laves86039153la_ves_
laxest134913363la_xest
laziest163814483laziest
leariest83117853leariest
lievest1048343lievest
livest95315733_livest
maddest112311213maddest
mares76457633mar_es_
margent10316693margent
marges94525713marges_
market123226043marke_t
markets133314033markets
marliest102415183marliest
marses84827113marses_
marvel113712003marve_l
marvels123810093marvels
matiest92522453matiest
mauves113811553mauves_
mayest114614793ma_yest
maziest183613873maziest
merest84725113mer_est
miriest93619823miriest
mirkest13309723mirkest
murkest133110203murkest
naives94914223naives_
narcist9512443narcist
nares55544153nar_es_
naves87030383na_ves_
nearest73415843near_est
nerves94216193nerves_
nerviest11188833nerviest
oakiest112913923oakiest
oarless73913373oarless
oaves84925613oa_ves_
paciest112917813paciest
palest83926223pa_lest
paliest93021613paliest
parent83230423par_ent
pares77164483par_es_
parges94529543parges_
parget94529393parge_t
pargets105215193pargets
paries84742513paries_
parles86334403parles_
parses85534703parses_
parve109824853parve__
parvenu1247023parvenu
parvis116114803parvis_
parvise124211693parvise
parvos116614753parvos_
paves104833923pa_ves_
peartest10311303peartest
pertest9317043pertest
pervert12315583pervert
phattest1336923phattest
preharvest1883363preharvest
prest75736353_pr_est
priest84125423_priest
purest84021933pur_est
raciest92820013raciest
rankest112713813rankest
rares55247443rar_es_
rashest103916873rashest
raves85441973ra_ves_
rawest93615063ra_west
rearrest8311603rearrest
reest54938093__reest
rest46459843__r_est
revest94623603_revest
saddest92412383saddest
safest95016603sa_fest
sagest74920263sa_gest
sagiest82617993sagiest
saltest71916513saltest
salves94221763salves_
sanest64426693sa_nest
sarees65329943sarees_
sarges75128593sarges_
sarkiest123615073sarkiest
sarment9318763sarment
saves85838633sa_ves_
savviest1435993savviest
sayest94217743sa_yest
scarcest12169173scarcest
scariest101615953scariest
scarves124511623scarves_
searest73322023sear_est
serest64831613ser_est
serves94423653serves_
shadiest121711283shadiest
shakiest151910943shakiest
shaliest111415063shaliest
shares95236413shar_es_
shaves125224933sha_ves_
shortest11310783shortest
smartest10310183smartest
sorest65028003sor_est
sparest94616433spar_est
sparsest1048823sparsest
spriest92718653spriest
spryest12247813spryest
starkest1239723starkest
starves104614553starves_
suavest10310623suavest
surest65026763sur_est
tallest7317093tallest
tamest85721293ta_mest
tannest72617853tannest
tardiest93515243tardiest
tares57456563tar_es_
targes74524603targes_
target75028913targe_t
targets84314223targets
tarres64723043tarres_
tarriest83215003tarriest
tartiest82718313tartiest
tautest72612443tautest
teariest82417263teariest
tersest71713993tersest
thraves13469713thraves_
traves94222743traves_
travesty1444483travesty
truest64816193_truest
turves94212693turves_
unrest62918853unr_est
vaguest1137333vaguest
vainest10315763vainest
valves124113783valves_
varies94330873varies_
varlet9423503varle_t
varlets10411573varlets
varment12313243varment
varve115716853varve__
varved134110603varve_d
vastest102911513vastest
veriest103719133veriest
verves124617883verves_
vervet124619063verve_t
vervets13419753vervets
vest75743603___vest
wackest164710863wackest
waives123714183waives_
waniest103819113waniest
wannest103915003wannest
wares88250583war_es_
warless104015103warless
wartiest113614643wartiest
wattest102412153wattest
waves115633923wa_ves_
waviest134513073waviest
waxiest173510883waxiest
weariest112914793weariest
wharve15456213wharve__
wherves16548063wherves_
wiriest103816853wiriest
wrest84925433_wr_est
wriest94419713_wriest
wryest12429113_wryest
zaniest163214773zaniest

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 Filter1786911340270.500357382.0
2DLD Change Limit1340274916.10621950.0
3Display Results4914910.1732838.2
 (SQL Overall)1786914916.77926359.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.