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

456 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
wharves1645714(None) 
wharve15456211wharve_
wherves16548061wherves
carves115128452_carves
chares115631802char_es
charges134615982charges
dwarves1434462dwarves
halves124717092_halves
hares86255542_har_es
harvest132112752_harvest
haves116034872_ha_ves
scarves124511622scarves
shares95236412shar_es
shaves125224932sha_ves
starves104614552starves
thraves13469712thraves
varves124414782_varves
waives123714182w_aives
wares88250582w_ar_es
waves115633922w_a_ves
wearies103020232wearies
weaves123616372wea_ves
whales124716942wha_les
wharfed1734422wharfed
wharfs1546372whar_fs
wheres125917442wher_es
wherve15568122wherve_
whores125617102whor_es
agaves104611513aga_ves
ares45871023__ar_es
arles56735743__arles
arses55733873__arses
arvos86015663__arvos
aves76142603__a_ves
barbes104526233_barbes
bardes95026933_bardes
bares75457133_bar_es
barges94528253_barges
barres84427553_barres
baryes116218503_baryes
behalves1644083behalves
behaves15198523beha_ves
bharals1236733bharals
blares85021633blar_es
braves115524083bra_ves
calves115119283_calves
cares77369183_car_es
caries85147623_caries
carles85435083_carles
carses85233653_carses
cartes86239473_cartes
carve106227753_carve_
carved124320853_carved
carvel114817573_carvel
carvels124914593_carvels
carven114716663_carven
carver114420153_carver
carvers124817543_carvers
caves105639703_ca_ves
chafes145017913cha_fes
chaines124518733chaines
chaises124317493chaises
chances145218093chances
changes134517583changes
chaoses124715123chaoses
chapes135421873cha_pes
charades141310853charades
charas114223613char_as
charases131312763charases
chards125119733char_ds
chare105231983char_e_
chared125423693char_ed
charge125114213charge_
charged144614023charged
charger133914063charger
chargers144011323chargers
charier124317903charier
chariest13315513chariest
charkas164810963charkas
charked174814013charked
charks155219703char_ks
charley15118273charley
charleys1695633charleys
charlies133414233charlies
charmed154714253charmed
charmer144913663charmer
charmers154211333charmers
charms135218843char_ms
charnel124010053charnel
charnels13328173charnels
charred134614493charred
charros124312153charros
charrs115219193char_rs
chars105936643char__s
charted135116853charted
charter123918303charter
charters134115583charters
charts115823093char_ts
chases115128233cha_ses
chasses124017503chasses
chevres15379793chevres
chirres123812253chirres
chives144317593ch_ives
chores114828023chor_es
claries93422203claries
claroes93113743claroes
claves115020063cla_ves
corves115122523_corves
craves115825393cra_ves
curves114619283_curves
dares66146703_dar_es
dearies83526273dearies
deaves105319533dea_ves
dharmas1356513dharmas
dharnas1155373dharnas
diaries83321953diaries
eaves85231993_ea_ves
ecartes94212563ecartes
farces115223323_farces
fares85852873_far_es
farles96025783_farles
fauves125610423_fauves
faves115331423_fa_ves
flares94521703flar_es
garvey13127873_garvey
garveys14124463_garveys
gharries12318223gharries
gharris11306433gharris
ghazies2036913ghazies
glaives11347833glaives
glares75518873glar_es
graves104624003gra_ves
hades96035113_ha_des
hadjes175210403_hadjes
haeres94017033_haeres
haes77651023_ha__es
hajes155420943_ha_jes
hajjes15485243_hajjes
hakes126034303_ha_kes
hales85449843_ha_les
haloes94623863_haloes
halvas124714173_halvas
halve114818923_halve_
halved134813903_halved
halvers133311423_halvers
hames106138703_ha_mes
hances115621283_hances
hanses95022633_hanses
haoles94919803_haoles
harass9313943_harass
harden105718533_harden
hardens113815023_hardens
harder105022403_harder
hardest113118413_hardest
hardies114923233_hardies
hards96435653_har_ds
hare76255733_har_e_
hared95742183_har_ed
hareem114312063_hareem
hareems12428203_hareems
harem104924453_har_em
harems115513823_harems
harked145422553_harked
harken135116343_harken
harkens144112863_harkens
harks126333433_har_ks
harls85634503_har_ls
harmed125218833_harmed
harmer114719553_harmer
harmers124116593_harmers
harms106829013_har_ms
harness102413933_harness
harped124418403_harped
harper115018403_harper
harpers124916203_harpers
harpies123818323_harpies
harps105926873_har_ps
harries103525503_harries
harts88441593_har_ts
harvests14246173_harvests
hashes125024803_hashes
hastes95727073_hastes
hates86742573_ha_tes
have106137073_ha_ve_
haven114718533_ha_ven
havens124514043_ha_vens
haver115124463_ha_ver
havers124721483_ha_vers
hawses125113993_hawses
hazes174928323_ha_zes
hearses104414543hearses
heaves124120303_heaves
helves124316063_helves
heres86245903_her_es
heroes94923833_heroes
herpes115517323_herpes
hirees95117293_hirees
hires86134343_hir_es
hives116925513_h_ives
hooves124815493_hooves
hordes104921633_hordes
horses94729353_horses
jarvey19135403_jarvey
jarveys20123413_jarveys
knaves13439523kna_ves
larees65323113_larees
lares54852633_lar_es
larges74824233_larges
larvas9310233_larvas
laves86039153_la_ves
leaves94222383lea_ves
loaves94813853loa_ves
mares76457633_mar_es
marges94525713_marges
marses84827113_marses
marvel113712003_marvel
marvels123810093_marvels
mauves113811553_mauves
naives94914223_naives
nares55544153_nar_es
naves87030383_na_ves
nerves94216193_nerves
oaves84925613_oa_ves
ovaries10312653ovaries
pares77164483_par_es
parges94529543_parges
paries84742513_paries
parles86334403_parles
parses85534703_parses
parve109824853_parve_
parvis116114803_parvis
parvos116614753_parvos
paves104833923_pa_ves
phages125213513pha_ges
pharos11312063phar_os
pharoses13310323pharoses
phases114618403pha_ses
phrases12711463phrases
quartes163314933quartes
rares55247443_rar_es
raves85441973_ra_ves
reaves94127573rea_ves
rhaphes1534703rhaphes
salves94221763_salves
sarees65329943_sarees
sarges75128593_sarges
saves85838633_sa_ves
scares85033003scar_es
serves94423653_serves
shades105924533sha_des
shakes135024593sha_kes
shakoes144510023shakoes
shales94731253sha_les
shames114726223sha_mes
shammes144312833shammes
shapes115124953sha_pes
shards104319173shar_ds
share86437083shar_e_
shared105829063shar_ed
sharer95025483shar_er
sharers104720623sharers
sharias102516003sharias
sharifs13279903sharifs
sharked153613913sharked
sharker144313813sharker
sharkers154011053sharkers
sharks135019723shar_ks
sharns95516983shar_ns
sharped134112053sharped
sharpen12389723sharpen
sharpens13377813sharpens
sharper124312703sharper
sharpers133810943sharpers
sharpest1339153sharpest
sharpies13411233sharpies
sharps115516083shar_ps
shave114425893sha_ve_
shaved135118383sha_ved
shaven124213303sha_ven
shaver123718913sha_ver
shavers134115093sha_vers
shavies134213213shavies
sheaves134412973sheaves
sheeves133911953sheeves
shelves134112093shelves
shires95225573shir_es
shives124921413sh_ives
shores94830413shor_es
shoves124919423sh_oves
shrives134416173shrives
slaves95023023sla_ves
snares65329033snar_es
soaves94218673soa_ves
spares84834553spar_es
sparges104016343sparges
stares66038753star_es
starve94613743starve_
starved114911573starved
starver104611993starver
starvers11459643starvers
staves94525193sta_ves
swerves1377533swerves
tares57456563_tar_es
targes74524603_targes
tarres64723043_tarres
thanes94918983tha_nes
tharms115712243thar_ms
theres96525473ther_es
thermes126214613thermes
thieves1346903thieves
thorpes125010353thorpes
thrave126010273thrave_
threes97117323th_rees
thrives134611713thrives
throes97518673th_roes
thyrses1335023thyrses
traves94222743tra_ves
turves94212693_turves
urares64519093urar_es
valves124113783_valves
varies94330873_varies
varve115716853_varve_
varved134110603_varved
verves124617883_verves
wackes154717713w_ackes
wades95634143w_a_des
wadies105121203w_adies
waes76048603w_a__es
wages95330933w_a_ges
wahines133111173wahines
waive114214603w_aive_
waived134511283w_aived
waiver124212713w_aiver
waivers133410053w_aivers
wakes126633653w_a_kes
wales86142833w_a_les
walies95324523w_alies
wames106432803w_a_mes
wanes85040883w_a_nes
warbles123215563w_arbles
warded115021043w_arded
warden104515513w_arden
wardens113711903w_ardens
warder104020273w_arder
warders113416813w_arders
wards97734403w_ar_ds
ware76254723w_ar_e_
wared96339873w_ar_ed
warier93722893w_arier
wariest105122503w_ariest
warked144421213w_arked
warks127932403w_ar_ks
warless104015103w_arless
warmed124516893w_armed
warmer113816733w_armer
warmers124514293w_armers
warmest123113033w_armest
warms107726853w_ar_ms
warned104018913w_arned
warner93717223w_arner
warners103315563w_arners
warns87231003w_ar_ns
warped124816413w_arped
warper114015583w_arper
warpers123413583w_arpers
warps107126423w_ar_ps
warred104019853w_arred
warren95012863w_arren
warrens103810893w_arrens
wars78659803w_ar__s
warsles103413643w_arsles
warted104223233w_arted
warts814840403w_ar_ts
washes124425493w_ashes
wastes96224883w_astes
wave105234733w_a_ve_
waved125223583w_a_ved
waver115025703w_a_ver
wavers125022473w_a_vers
wavey145115543w_a_vey
waveys15597013w_a_veys
wavies125019843w_avies
waxes155825503w_a_xes
wearer94319413wear_er
wearers104615903wearers
wearied112911823wearied
wearier103613293wearier
weariest112914793weariest
wears86030303wear__s
weave115218533wea_ve_
weaved133913483wea_ved
weaver123916613wea_ver
weavers133714463wea_vers
whacked20458623whacked
whacker19368503whacker
whackers20326543whackers
whackos19375263whackos
whacks184610483wha_cks
whale115517433wha_le_
whaled134612033wha_led
whaler124611973wha_ler
whalers13529703whalers
whammed18345133whammed
whammies18265513whammies
whams135515643wha__ms
whanged15447613whanged
whangee14268623whangee
whangees15275063whangees
whangs13439723wha_ngs
whapped18367573whapped
whapper17348273whapper
whappers18276743whappers
whaps135115163wha__ps
wharf14315823whar__f
wharfages1942643wharfages
whatever1742673whatever
whatness1435093whatness
whats117718993wha__ts
whatsis1335253whatsis
whaups14405753wha_ups
wheezes22306813wheezes
where117019433wher_e_
whereas13448903whereas
wherever1743833wherever
wherries14179033wherries
whiles124418013wh_iles
whines125120103wh_ines
whinges143610633whinges
whirled14368043whirled
whirler13307603whirler
whirlers14286053whirlers
whirlies14167373whirlies
whirls124710533whir_ls
whirred14386943whirred
whirries14136703whirries
whirrs12408593whir_rs
whirs115218093whir__s
whishes16309443whishes
whites123919883wh_ites
whities133113253whities
whizzes2134713whizzes
whoever1634103whoever
wholes124616773wh_oles
whore116018043whor_e_
whored135512123whor_ed
whorled14366903whorled
whorls124410163whor_ls
whortles14306743whortles
whorts125111433whor_ts
wires86034913w_ir_es
wives115328923w__ives
wolves124510853w_olves
worries104117133worries
worses95522953w_orses
wrasses103812593wrasses
wries85827743w__ries

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.406440125.6
2DLD Change Limit1340274566.97019229.1
3Display Results4564560.1562923.1
 (SQL Overall)1786914567.53223724.2
 
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.