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

335 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
dwarves143446(None) 
carves115128452_carves
dares66146702d_ar_es
dearies83526272dearies
deaves105319532dea_ves
diaries83321952diaries
dwarfed1533482dwarfed
dwarfer1433682dwarfer
dwarfest1543472dwarfest
dwarfs13436272dwar_fs
scarves124511622scarves
starves104614552starves
swerves1377532swerves
varves124414782_varves
waives123714182_waives
wares88250582_war_es
waves115633922_wa_ves
wharves16457132wharves
agaves104611513aga_ves
ares45871023__ar_es
arles56735743__arles
arses55733873__arses
arvos86015663__arvos
aves76142603__a_ves
awakes135012473awa_kes
awarded1236223awarded
awardee1137563awardee
awardees1243993awardees
awarder1135893awarder
awarders1245073awarders
awards107113453awar_ds
aware86420023awar_e_
barbes104526233_barbes
bardes95026933_bardes
bares75457133_bar_es
barges94528253_barges
barres84427543_barres
baryes116218503_baryes
bewares12313373bewar_es
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
chares115631803char_es
charges134615983charges
claries93422203claries
claroes93113733claroes
claves115020063cla_ves
corves115122523_corves
craves115825393cra_ves
curves114619283_curves
daces85030683d_a_ces
dadoes85616533d_adoes
dagoes85714603d_agoes
dairies84217733dairies
daises74318983d_aises
dales66439743d_a_les
dalles74222063d_alles
dames85435853d_a_mes
dances95120653d_ances
darbies104216983d_arbies
darbs85323263d_ar_bs
dare55848863d_ar_e_
dared75935013d_ar_ed
darer65230793d_ar_er
darers75921873d_arers
darics94314113d_arics
darked123919633d_arked
darken114013443d_arken
darkens12409873d_arkens
darker114718693d_arker
darkest122512623d_arkest
darkey145212423d_arkey
darkeys15356533d_arkeys
darkies124015753d_arkies
darkles124011933d_arkles
darks106727873d_ar_ks
darned85018483d_arned
darnel74312183d_arnel
darnels83710433d_arnels
darner74017303d_arner
darners83815773d_arners
darns66927893d_ar_ns
darted84620923d_arted
darter75320363d_arter
darters84017603d_arters
dartles84014133d_artles
darts67635733d_ar_ts
dashes106124983d_ashes
dataries9314033dataries
dates65639153d_a_tes
datives11310073datives
daubes94913703d_aubes
daven94916473d_a_ven
davens104612913d_a_vens
davies105020513d_avies
dawdles12379163dawdles
dawties113312703dawties
dazes155024143d_a_zes
dearer74822803dear_er
dearest83618673dear_est
dearie73319813dearie_
dearness939973dearness
dears65736883dear__s
dearths11498843dearths
deashes113313903deashes
deave95022333dea_ve_
deaved114916553dea_ved
decares102818533decar_es
decrees102513123decrees
decries103319803decries
decurves1435863decurves
degrees92810723degrees
dekares122710873dekar_es
delves104917083d_elves
depraves1436873depraves
deprives1438393deprives
derates84028893derates
derives114017813derives
derries83124623derries
deserves12109893deserves
dewars105117073dewar__s
dewaxes18297843dewa_xes
dharmas1356513dharmas
dharnas1155373dharnas
dirges84915103d_irges
dives95832403d__ives
dories75232363d_ories
doves94728153d__oves
doweries12411933doweries
dowries114413983dowries
dragees9359483dragees
drakes114715863dra_kes
drapes95419653dra_pes
drave95219273dra_ve_
drawees11378363drawees
drearies92313413drearies
drees65628523d__rees
dries64733673d__ries
drives105117113d_rives
droves105116673d_roves
dures65635923d_ur_es
durries83817353durries
dwarf126015243dwar__f
dwarfish1843783dwarfish
dwarfism1742293dwarfism
dwarfness1642793dwarfness
dwines105013103dw_ines
eaves85231993_ea_ves
ecartes94212563ecartes
farces115223323_farces
fares85852873_far_es
farles96025783_farles
fauves125610423_fauves
faves115331423_fa_ves
flares94521703flar_es
garvey13127873_garvey
garveys14124463_garveys
glaives11347833glaives
glares75518873glar_es
graves104624003gra_ves
halves124717093_halves
hares86255543_har_es
harvest132112753_harvest
haves116034873_ha_ves
hearses104414533hearses
heaves124120303hea_ves
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
quartes163314933quartes
rares55247443_rar_es
raves85441973_ra_ves
reaves94127573rea_ves
redwares1239053redwar_es
salves94221763_salves
sarees65329943_sarees
sarges75128593_sarges
saves85838633_sa_ves
scares85033003scar_es
serves94423653_serves
shares95236413shar_es
shaves125224933sha_ves
slaves95023023sla_ves
snares65329033snar_es
soaves94218673soa_ves
spares84834553spar_es
sparges104016343sparges
stares66038753star_es
starve94613743starve_
starved114911573starved
starver104611993starver
starvers11459643starvers
staves94525193sta_ves
swages104417073swa_ges
swales93920763swa_les
swamies123712063swamies
swarajes1843743swarajes
swarded1238153swarded
swards105415133swar_ds
sware85828213swar_e_
swarfs125612063swar_fs
swarmed1367483swarmed
swarmer1247803swarmer
swarmers1346323swarmers
swarms116112173swar_ms
swarths13537323swarths
swashes134714403swashes
swathes134115513swathes
swerve1256293swerve_
swerved1455703swerved
swerver1365733swerver
swervers1455213swervers
swives123915183sw_ives
tares57456563_tar_es
targes74524593_targes
tarres64723043_tarres
thraves13469713thraves
traves94222743tra_ves
turves94212693_turves
twaes86513663twa__es
twelves1334303twelves
urares64519093urar_es
valves124113783_valves
varies94330873_varies
varve115716853_varve_
varved134110603_varved
verves124617883_verves
wackes154717713_wackes
wades95634143_wa_des
wadies105121203_wadies
waes76048603_wa__es
wages95330933_wa_ges
waive114214603_waive_
waived134511283_waived
waiver124212713_waiver
waivers133410053_waivers
wakes126633653_wa_kes
wales86142833_wa_les
walies95324523_walies
wames106432803_wa_mes
wanes85040883_wa_nes
warbles123215563_warbles
warded115021043_warded
warden104515513_warden
wardens113711903_wardens
warder104020273_warder
warders113416813_warders
wards97734403_war_ds
ware76254723_war_e_
wared96339873_war_ed
warier93722893_warier
wariest105122503_wariest
warked144421213_warked
warks127932403_war_ks
warless104015103_warless
warmed124516893_warmed
warmer113816733_warmer
warmers124514293_warmers
warmest123113033_warmest
warms107726853_war_ms
warned104018913_warned
warner93717223_warner
warners103315563_warners
warns87231003_war_ns
warped124816413_warped
warper114015583_warper
warpers123413583_warpers
warps107126423_war_ps
warred104019843_warred
warren95012853_warren
warrens103810893_warrens
wars78659803_war__s
warsles103413643_warsles
warted104223233_warted
warts814840403_war_ts
washes124425493_washes
wastes96224883_wastes
wave105234733_wa_ve_
waved125223583_wa_ved
waver115025703_wa_ver
wavers125022473_wa_vers
wavey145115543_wa_vey
waveys15597013_wa_veys
wavies125019843_wavies
waxes155825503_wa_xes
wearies103020223wearies
weaves123616373_weaves
wharve15456203wharve_
wherves16548053wherves
wires86034913_wir_es
wives115328923_w_ives
wolves124510853_wolves
worses95522953_worses
wries85827743_w_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.420425454.8
2DLD Change Limit1340273356.62620227.4
3Display Results3353350.1103045.5
 (SQL Overall)1786913357.15624970.8
 
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.