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

200 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
dozening1923618(None) 
cozening20188301cozening
dizening19177141dizening
dovening13238351dovening
davening13258872davening
donning93512762do_nning
doweling13279762doweling
dowering132510612dowering
downing123811672do_wning
dozing174214192doz__ing
omening10310092_omening
opening1039922_opening
tokening1336462tokening
wizening21255462wizening
adorning1087323ado_rning
aliening91510893aliening
bedizening2392663bedizening
bogeying1575703bogeying
boning94223293bo__ning
boweling143410683boweling
bowering142911713bowering
brazening2185183brazening
cohering142413833cohering
coigning1237173coigning
coining103920543co_ining
coning94331823co__ning
conning103718753co_nning
convening15311193convening
cooeeing1137453cooeeing
cooeying1438143cooeying
corning103720123co_rning
covering142215723covering
coveting141912303coveting
cowering142514033cowering
cozying22308063coz_ying
damning114211633d_amning
dampening1535463dampening
darkening1535683darkening
darning93817333d_arning
dawning124111013d_awning
dazing175516513daz__ing
dazzling1834363dazzling
deadening1277583deadening
deafening1476273deafening
deaning94020473d_eaning
deboning12109153deboning
decerning1337293decerning
deeding103315123d_eeding
deeming113913123d_eeming
deepening1335613deepening
defencing16226693defencing
defending15298353defending
defensing14217003defensing
defining133711803defining
deigning1137753deigning
dekeing13358353deke_ing
deking125614553d__eking
deleing93313953dele_ing
deleting103314423deleting
demeaning1337243demeaning
dementing13311043dementing
denizening2142403denizening
denning93515173d_enning
denting94422183d__enting
denying123711293d__enying
depending14208783depending
deponing121211213deponing
desexing1736293desexing
deveining1436393deveining
develing133212733develing
dewing114115703d__ewing
dezincing2244183dezincing
dieing84018653d_ie_ing
dieting93616833d_ieting
dining84525133d__ining
dinning93416553d_inning
divining1338413divining
dizzying2133023dizzying
doating93816863do_ating
docketing1785413docketing
docking153615013do_cking
doddering1335183doddering
dodging11299063do_dging
doffing15357793do_ffing
dogearing1235763dogearing
dogging113312693do_gging
doggoning1343563doggoning
doing74923583do___ing
doling84923133do__ling
dolling93817373do_lling
dollying13407413dollying
doming104218393do__ming
donating10311803donating
doodling11218403doodling
dooming113112533do_oming
doping103919463do__ping
dosing83920273do__sing
dossing93313273do_ssing
doting84821913do__ting
dotting93314483do_tting
doubling1238153doubling
doubting1237373doubting
douching15349843douching
dousing93315763do_using
dowelling1466253dowelling
dowing114221513do__wing
downzoning2441583downzoning
dowsing123411123do_wsing
doyenne1143883doyen_ne
dozen155017473doze__n_
dozened18377453dozen_ed
dozens164612463doze__ns
dozenth2044323dozen_th
dozenths2142793dozenths
draining103312673draining
dreeing94311183d_reeing
droning93013723d_roning
drowning13298363drowning
dueling93614543d_ueling
dueting93814393d_ueting
dunning93514473d_unning
durning93511733d_urning
dwining12269293d_wining
dyeing11428213d_ye_ing
evening11310223_evening
foining113013453fo_ining
fomenting1537233fomenting
forewing1539003forewing
governing1435533governing
gowning12258833go_wning
greening103112533greening
havening15258553havening
hoeing104117023ho_e_ing
hoidening1435633hoidening
homering141512073homering
honeying1537673honeying
honing103421503ho__ning
horning113015003ho_rning
hoseying1537193hoseying
hoveling15189593hoveling
hovering151911143hovering
hoydening1744353hoydening
joining153011483jo_ining
jonesing1636633jonesing
keening123713153_keening
ladening1078823ladening
latening9711493latening
likening13246893likening
livening12248153livening
loaning83614833lo_aning
loosening1044933loosening
loudening1144743loudening
lowering122210913lowering
moaning103714443mo_aning
modeling12311073modeling
modeming1437103modeming
mooning103415553mo_oning
morning103215043mo_rning
moseying1436853moseying
mourning1156793mourning
nonending1138003nonending
nooning83014853no_oning
obeying1336543_obeying
oozing163812203ooz__ing
openings1134803_openings
opining10311743_opining
overing111918053_overing
owning104110333_o_wning
peening103318303_peening
pollening1236923pollening
powering142210803powering
preening113115843preening
queening1846113queening
ravening122611293ravening
razeeing1834363razeeing
reopening1248823reopening
rezoning18310453rezoning
ripening1138573ripening
rodeoing1037253rodeoing
rogering10310273rogering
rosining92411423rosining
roweling122811123roweling
sheening123010803sheening
sobering111912783sobering
soddening1244543soddening
softening1365493softening
sorning83116813so_rning
toeing74418473to_e_ing
toning74025793to__ning
toweling122910373toweling
towering122610873towering
wakening1636323wakening
weening114113973_weening
widening13237833widening
womaning1437643womaning
wonning113210793wo_nning
worsening1345553worsening
yodeling1357673yodeling
zoning162914333__zoning
zooning172910703zo_oning

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.1561145455.1
2DLD Change Limit1461622008.12317993.6
3Display Results2002000.0802500.0
 (SQL Overall)1786912008.35921377.1
 
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.