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

211 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
howdying193371(None) 
bodying1438972bo_dying
hogtying1633552hogtying
holding123514282hold_ing
hondling132210012hondling
honeying1537672honeying
hooding123815202hood_ing
hording123517052hord_ing
hoseying1537192hoseying
howking183610312how_king
howling143413162how_ling
toadying1335042toadying
bandying15218073bandying
bloodying1643783bloodying
boding104320063bo_d_ing
bogeying1575703bogeying
bonding113318433bond_ing
boodling121910243boodling
boogying1535373boogying
boweling143410683boweling
bowering142911713bowering
bowing124723063bow__ing
bowling133916493bow_ling
bowsing134012503bow_sing
buddying16274793buddying
caddying16225063caddying
candying15188993candying
chording15410153chord_ing
chowdering2044163chowdering
chowing164412773chow__ing
chowsing17217343chow_sing
codding124014693co_dding
coddling13258473coddling
coding104024793co_d_ing
codling114418953co_dling
collying14319543collying
cooeying1438143cooeying
copying153411983co_pying
cording113620823cord_ing
cosying134513133co_sying
cowboying2043183cowboying
cowering142514033cowering
cowing124526323cow__ing
cowling134017413cow_ling
coying124021483co__ying
cozying22308063co_zying
crowding15247933crowd_ing
dawdling14236373dawdling
dodging11299063do_dging
dollying13407413dollying
doodling11218403doodling
dowdyish1952833dowdyish
doweling13279763doweling
dowering132510613dowering
dowing114221513dow__ing
downing123811673dow_ning
dowsing123411123dow_sing
dying105316033___dying
eddying1335293_eddying
folding123912443fold_ing
fonding123815423fond_ing
fondling13189353fondling
fonduing13245893fonduing
foraying1537433foraying
fording123717033ford_ing
fordoing1357293fordoing
fowling143713113fow_ling
giddying1533773giddying
goading103112853goad_ing
godding113911943go_dding
godling103513403go_dling
gowning12258833gow_ning
hading113922943h_ad_ing
handing123518893hand_ing
handling132312713handling
harrying15157633harrying
hawing134322353haw__ing
hawking183711423haw_king
haying134420613h__aying
heading122919113head_ing
hedging13348953h_edging
heeding123515063heed_ing
herding122915123herd_ing
herrying15147013herrying
hewing134514243hew__ing
hiding114319333h_id_ing
hilding123713533hild_ing
hinnying15124853hinnying
hoarding13288643hoarding
hoaxing18307763ho_axing
hobbing152811123ho_bbing
hobbling16227583hobbling
hoboing13309453ho_boing
hocking173417243ho_cking
hocusing1446583hocusing
hoddin11369933ho_ddin_
hoddins12289373ho_ddins
hoeing104117023ho__eing
hogging133112803ho_gging
hoicking1836053hoicking
hoidening1435633hoidening
hoising113414413ho_ising
hoisting123610903hoisting
hoking144419513ho__king
holdings13297743hold_ings
holidaying1842393holidaying
holing104025073ho__ling
holking153512313ho_lking
hollaing12167093hollaing
holloing12148823holloing
homaging1536613homaging
homering141512073homering
homing123718383ho__ming
hongiing1335603hongiing
honing103421503ho__ning
honking153414793ho_nking
honoring12310473honoring
hoodooing14103933hoodooing
hoodwink1942903hoodwink
hoofing143912553ho_ofing
hooking153716693ho_oking
hooping133615703ho_oping
hooraying1644783hooraying
hooting113919873ho_oting
hoping123719743ho__ping
hopping154115273ho_pping
hoppling16206763hoppling
hordein1138753hordein_
hordeins1238323hordeins
horning113015003ho_rning
horsing113215583ho_rsing
hosing103421103ho__sing
hosting114318383ho_sting
hotching17309313hotching
hotting113116513ho_tting
hounding132610053hounding
housing113316523ho_using
hoveling15189593hoveling
hovering151911143hovering
howdie13349723howd_i_e
howdied15296843howd_ied
howdies142911953howd_ies
howdy155711413howdy___
hoydening1744353hoydening
huddling14227293huddling
hurdling13288013hurdling
hurrying15145523hurrying
hying126514743h___ying
jollying19316053jollying
jowing174216043jow__ing
joying173810803jo__ying
loading94114613load_ing
lobbying1633603lobbying
lodging103110813lo_dging
loiding93313403loid_ing
lording93115233lord_ing
lordling1077743lordling
lowering122210913lowering
lowing104623273low__ing
molding114213753mold_ing
moseying1436853moseying
mowing124119093mow__ing
muddying16254543muddying
nodding103811513no_dding
noddling11237253noddling
nondrying1444683nondrying
noodging11185693noodging
noodling10209443noodling
obeying1336543_obeying
okaying1534833_okaying
owing96222723_ow__ing
owning104110333_ow_ning
pandying15217663pandying
phoneying1844283phoneying
phonying1745833pho_nying
podding124113183po_dding
ponding114317083pond_ing
ponying133312123po_nying
powdering16246493powdering
powering142210803powering
readying13410223readying
rodding103814533ro_dding
rowdyish1852663rowdyish
rowdyism1752153rowdyism
roweling122811123roweling
rowing103623303row__ing
showering1646403showering
showing143814653show__ing
showring1548313show_ring
sodding103712733so_dding
sowing104222913sow__ing
studying1335553studying
swaying143610643_swaying
tidying1238513_tidying
toddling11187003toddling
toweling122910373toweling
towering122610873towering
towing103823193tow__ing
toying105017303to__ying
undying1238503_undying
voiding122910363void_ing
vowing133715273vow__ing
waddying17204723waddying
wooding123012023wood_ing
wording123014563word_ing
worrying1534693worrying
wowing133915393wow__ing
wrying13379623__wrying
yodling123610253yo_dling
yowing133715543yow__ing
yowling143610223yow_ling

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 Filter1786911461620.1731032896.0
2DLD Change Limit1461622117.37619815.9
3Display Results2112110.0762776.3
 (SQL Overall)1786912117.62523434.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.