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

309 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
davening1325887(None) 
dovening13238351dovening
havening15258551havening
ravening122611291ravening
avenging1345862_avenging
caverning1536282caverning
cravening1547552cravening
damning114211632da_mning
dampening1535462dampening
darkening1535682darkening
darning93817332da_rning
dawning124111012da_wning
deadening1277582deadening
deafening1476272deafening
deveining1436392deveining
develing133212732develing
divining1338412divining
dizening19177142dizening
dozening19236182dozening
evening11310222_evening
gaveling133410162gaveling
havering152211052havering
ladening1078822ladening
latening9711492latening
leavening1365972leavening
livening12248152livening
raveling123414372raveling
ravenings13235182ravenings
ravining12269692ravining
wakening1636322wakening
wavering152410542wavering
adeeming1254793adeeming
adenine8311213_adenine
adhering1338883adhering
adorning1087323adorning
advancing1643063advancing
advecting1645113advecting
adverting1437223adverting
advising1336153advising
ageing84213403_age_ing
agenting1039383_agenting
aliening91510893aliening
alining81917043_alining
amending12308913_amending
aneling82719503_aneling
atoning83514873_atoning
averring12239063_averring
averting122512733_averting
avowing1466603_avowing
awakening1743203awakening
aweing103911253_awe_ing
awning105013393_a_wning
baning95127833ba__ning
banning103818233ba_nning
barning104320353ba_rning
battening12268853battening
beavering1538703beavering
beveling143011033beveling
brazening2185183brazening
cabining1338643cabining
cadencing1544963cadencing
cageling12310843cageling
cameoing1379063cameoing
caning94128623ca__ning
canning103620133ca_nning
capering132414963capering
careening12310013careening
catering112019903catering
caveating1539293caveating
caviling14310113caviling
caving124822613cav__ing
clavering1538373clavering
convening15311193convening
covering142215723covering
coveting141912303coveting
cozening20188303cozening
dabbing133511233da_bbing
dabbling14227973dabbling
dackering1737383dackering
daddling12258233daddling
dadoing1038523da_doing
daffing15369733da_ffing
daggering13246113daggering
daggling12237063daggling
daikering1536103daikering
dairying1336353dairying
dallying13368493dallying
damaging1337383damaging
damming133812743da_mming
damping133414003da_mping
dancing113611563da_ncing
dandering122511063dandering
dandling112511733dandling
dangering12239303dangering
danging103716093da_nging
dangling112611233dangling
dapping133714793da_pping
dappling1436843dappling
daring84928683da__ring
darking134217343da_rking
darkling1437483darkling
darling93418363da_rling
darnings10378553da_rnings
darting94020663da_rting
dartling1039563dartling
dashing125917893da_shing
dateline9810353dateline
datelining1244363datelining
dating85326483da__ting
daubing11358623da_ubing
daunting103310403daunting
dauting93814763da_uting
daven94916473dave__n_
davened124610073daven_ed
davens104612913dave__ns
dawdling14236373dawdling
dawing114819823da__wing
dawting123610673da_wting
dazing175516513da__zing
dazzling1834363dazzling
deaconing1337193deaconing
deadenings1393323deadenings
deafenings1562503deafenings
deaning94020473d_eaning
deaving123814753deav__ing
deboning12109153deboning
decerning1337293decerning
deeding103315123d_eeding
deeming113913123d_eeming
deepening1335613deepening
defencing16226693defencing
defending15298353defending
defensing14217003defensing
defining133711803defining
deigning1137753deigning
dekeing13358353deke_ing
deking125614553d__eking
deleing93313953dele_ing
deleting103314423deleting
demeaning1337243demeaning
dementing13311043dementing
denning93515173d_enning
denting94422183d__enting
denying123711293d__enying
depending14208783depending
deponing121211213deponing
desexing1736293desexing
devein1039143deve_in_
deveins1138813deve_ins
devesting14249903devesting
deviling1311812853deviling
devising133111523devising
devoting1338823devoting
dewing114115703d__ewing
diademing1454323diademing
diapering1339033diapering
dieing84018653d_ie_ing
dieting93616833d_ieting
dining84525133d__ining
dinning93416553d_inning
diverging15226693diverging
diverting142410333diverting
divesting14298483divesting
dividing1437183dividing
diving113717953div__ing
divvying1932773divvying
donning93512763d_onning
doweling13279763doweling
dowering132510613dowering
downing123811673d_owning
draining103312673draining
dreeing94311183d_reeing
driveling1445763driveling
droning93013723d_roning
drowning13298363drowning
dueling93614543d_ueling
dueting93814393d_ueting
dunning93514473d_unning
durning93511733d_urning
duvetine1245163duvetine
dwining12269293d_wining
dyeing11428213d_ye_ing
earning83418213ea_rning
evenings1234383_evenings
faceting1438783faceting
fanning113615073fa_nning
fastening13268603fastening
fattening13287833fattening
favoring1596673favoring
fawning14409133fa_wning
fevering152510083fevering
gaeing84617223ga_e_ing
gaining94015663ga_ining
gardening1236513gardening
gavelling14286873gavelling
governing1435533governing
graveling1457383graveling
greening103112533greening
haeing104118923ha_e_ing
happening1735593happening
hardening1438023hardening
harkening1746923harkening
hastening13259483hastening
having134220373hav__ing
hoveling15189593hoveling
hovering151911143hovering
inventing13109973inventing
javelin17306983javelin_
javelina18315453javelina
javelining2142513javelining
javelins18277733javelins
keening123713153_keening
labeling11311643labeling
lacewing1435843lacewing
lagering102212313lagering
lamenting1237693lamenting
laveering1336813laveering
laving104623573lav__ing
layering122310353layering
leadening1176733leadening
leavenings1472583leavenings
leveeing12265963leveeing
leveling122910433leveling
levering122212503levering
likening13246893likening
livering122012383livering
maddening1445113maddening
manning103616383ma_nning
marveling1537103marveling
masoning1139763masoning
neatening1038353neatening
omening10310093_omening
opening1039923_opening
overing111918053_overing
paining103920243pa_ining
paneling111013623paneling
panning104019393pa_nning
papering132213313papering
parenting12611583parenting
patenting1248943patenting
patining11312303patining
paving124519743pav__ing
pavonine1346663pavonine
pawning134711413pa_wning
peening103318303_peening
preening113115843preening
quavering2235953quavering
queening1846113queening
raining83922693ra_ining
rattening10288763rattening
ravaging1346323ravaging
ravelin102211023ravelin_
ravelings13377383ravelings
ravelins113011603ravelins
ravelling13269243ravelling
raving105128853rav__ing
razeeing1834363razeeing
reveling123117083reveling
revenging1438083revenging
revering122918073revering
ripening1138573ripening
riveting12139443riveting
sabeing102611863sabe_ing
sabering112113743sabering
saddening1245213saddening
saining83621393sa_ining
saning75127643sa__ning
savaging1356673savaging
saving104724513sav__ing
savoring1269483savoring
savvying1862723savvying
scavenging1742073scavenging
severing122013853severing
shaveling1646843shaveling
sheening123010803sheening
slavering1338723slavering
subvening1546033subvening
tabering112211423tabering
tanning83618253ta_nning
tapering112112503tapering
tautening1035843tautening
tokening1336463tokening
traveling1349053traveling
valeting1238843valeting
vanning113912463va_nning
veining114713893__veining
vending124015263__vending
venging123710943__venging
venin85118663__venin_
venine93718433__venine
venins93816703__venins
venting114218093__venting
vexing17479173__vexing
vining104619463__vining
wafering15208893wafering
wagering13219523wagering
wagoning1336923wagoning
wakenings1743043wakenings
waning103623803wa__ning
wanning113816213wa_nning
warning113717093wa_rning
watering122316313watering
waving134018203wav__ing
weakening1734843weakening
weening114113973_weening
widening13237833widening
wizening21255463wizening
yarning113512953ya_rning
yawning14378343ya_wning

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 Filter1786911461620.420425454.8
2DLD Change Limit1461623097.44019645.4
3Display Results3093090.1402207.1
 (SQL Overall)1786913098.00022336.4
 
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.