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

285 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
havening1525855(None) 
davening13258871davening
havering152211051havering
ravening122611291ravening
avenging1345862_avenging
caverning1536282caverning
cravening1547552cravening
dovening13238352dovening
evening11310222_evening
gaveling133410162gaveling
haeing104118922ha_e_ing
happening1735592happening
hardening1438022hardening
harkening1746922harkening
hastening13259482hastening
having134220372hav__ing
hoveling15189592hoveling
hovering151911142hovering
ladening1078822ladening
latening9711492latening
leavening1365972leavening
livening12248152livening
raveling123414372raveling
ravenings13235182ravenings
ravining12269692ravining
shaveling1646842shaveling
wakening1636322wakening
wavering152410542wavering
adenine8311213_adenine
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
chaining142810783cha_ining
chastening1656523chastening
cheapening1883803cheapening
clavering1538373clavering
convening15311193convening
covering142215723covering
coveting141912303coveting
cozening20188303cozening
damning114211633da_mning
dampening1535463dampening
darkening1535683darkening
darning93817333da_rning
dawning124111013da_wning
deadening1277583deadening
deafening1476273deafening
deveining1436393deveining
develing133212733develing
divining1338413divining
dizening19177143dizening
dozening19236183dozening
earning83418213ea_rning
evenings1234383_evenings
faceting1438783faceting
fanning113615073fa_nning
fastening13268603fastening
fattening13287833fattening
favoring1596673favoring
fawning14409133fa_wning
fevering152510083fevering
gaeing84617223ga_e_ing
gaining94015663ga_ining
gardening1236513gardening
gavelling14286873gavelling
governing1435533governing
graveling1457383graveling
greening103112533greening
habiting1437533habiting
hacking173720613ha_cking
hackling183310163hackling
hading113922943ha__ding
haemin113412663ha_emin_
haemins122811403ha_emins
hafting144014173ha_fting
hagging133114683ha_gging
haggling14227273haggling
hailing113820693ha_iling
haling104229783ha__ling
halloing121510073halloing
haloing113814133ha_loing
haltering132212003haltering
halting114419073ha_lting
halving143511543ha_lving
hamboning1745893hamboning
hammering1737633hammering
hamming153014093ha_mming
hampering1738863hampering
handing123518893ha_nding
handling132312713handling
hanging123518703ha_nging
hankering17239383hankering
hanking154619103ha_nking
hanseling1338063hanseling
hanting114124483ha_nting
happenings1842623happenings
happing153817233ha_pping
hardenings1544243hardenings
haring104233003ha__ring
harking154120943ha_rking
harming133717933ha_rming
harping134118383ha_rping
harrying15157643harrying
harshening1744173harshening
harvesting1744413harvesting
hashing145020163ha_shing
hasping134414903ha_sping
hassling1236803hassling
hasting114725193ha_sting
hatching173312213hatching
hating104929713ha__ting
hatting113920233ha_tting
hauling113714433ha_uling
haunting123510053haunting
haven114718533have__n_
havened14429243haven_ed
havens124514043have__ns
havocking2242773havocking
hawing134322353ha__wing
hawking183711423ha_wking
haying134420613ha__ying
hazing194218553ha__zing
hearkening1844533hearkening
heartening1446733heartening
heaving144114763heav__ing
heeding123515063h_eeding
heeling113618513h_eeling
heezing20349873h_eezing
henting113719653h__enting
hewing134514243h__ewing
hexing174210513h__exing
hieing104216623h_ie_ing
hireling121210993hireling
hiving134115523hiv__ing
hoarsening1444403hoarsening
hoeing104117023h_oe_ing
hoidening1435633hoidening
homering141512073homering
honeying1537673honeying
honing103421503h__oning
hoovering1635753hoovering
horning113015003h_orning
hoseying1537193hoseying
hovelling1636163hovelling
hoydening1744353hoydening
hyenine1336953h_yenine
hymning1635183h_ymning
hyphening2144143hyphening
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
sharpening1644883sharpening
shavelings1743503shavelings
shaving143414333shav__ing
sheening123010803sheening
shivering1637333shivering
shoveling1635553shoveling
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
whitening1635103whitening
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.453394461.4
2DLD Change Limit1461622857.51319454.5
3Display Results2852850.1262261.9
 (SQL Overall)1786912858.09222082.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.