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

210 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
hogtying163355(None) 
bogeying1575702bogeying
hogging133112802hog_ging
hogtieing1442862hogtieing
honeying1537672honeying
hooting113919882hoot_ing
hoseying1537192hoseying
hosting114318382host_ing
hotting113116522ho_tting
howdying1933712howdying
boating103721303boat_ing
bodying1438973bo_dying
bogging123615753bog_ging
boggling13257163boggling
bolting104416763bolt_ing
boogeying1643623boogeying
boogying1535373boogying
booting103821363boot_ing
bottling11279143bottling
chortling1535563chortling
coating103525313coat_ing
cogging123513713cog_ging
collying14319543collying
cooeying1438143cooeying
copying153411983co_pying
costing104323023cost_ing
cosying134513133co_sying
coting94629253co_t_ing
coying124021483co__ying
cozying22308063co_zying
dirtying1336093dirtying
doating93816863doat_ing
dogging113312693dog_ging
dollying13407413dollying
doting84821913do_t_ing
dotting93314483do_tting
emptying1634243emptying
fogging133513733fog_ging
footing115017593foot_ing
footling12239923footling
foraying1537433foraying
ghosting1336463ghost_ing
goggling10246283goggling
guying11379723__guying
hafting144014173haft_ing
hagging133114683hag_ging
haggling14227273haggling
halting114419073halt_ing
hanting114124483hant_ing
harrying15157643harrying
hasting114725193hast_ing
hating104929713h_at_ing
hatting113920233h_atting
haying134420613h__aying
heating114024323heat_ing
hefting144510913heft_ing
henting113719653hent_ing
herrying15147023herrying
higgling14217163higgling
highting16259723highting
hilting113316893hilt_ing
hinnying15124853hinnying
hinting113919223hint_ing
histing113720373hist_ing
hitting113017273h_itting
hoarding13288643hoarding
hoatzin1943943hoatzin_
hoatzins2043843hoatzins
hoaxing18307763ho_axing
hobbing152811123ho_bbing
hobbling16227583hobbling
hoboing13309453ho_boing
hocking173417243ho_cking
hocusing1446583hocusing
hoeing104117023ho__eing
hogtie102711773hogt_i_e
hogtied12226653hogt_ied
hogties112813993hogt_ies
hoicking1836053hoicking
hoising113414413ho_ising
hoisting123610903hoisting
hoking144419513ho__king
holding123514283ho_lding
holing104025073ho__ling
holking153512313ho_lking
hollaing12167093hollaing
holloing12148823holloing
homaging1536613homaging
homering141512073homering
homing123718383ho__ming
hondling132210013hondling
hongiing1335603hongiing
honing103421503ho__ning
honking153414793ho_nking
honoring12310473honoring
hooding123815203ho_oding
hoofing143912553ho_ofing
hooking153716693ho_oking
hooping133615703ho_oping
hooraying1644783hooraying
hoping123719743ho__ping
hopping154115273ho_pping
hoppling16206763hoppling
hording123517053ho_rding
horning113015003ho_rning
horsing113215583ho_rsing
hosing103421103ho__sing
hosteling1337893hosteling
hotching17309313hotching
hotline10712353ho_tline
hotlink1476763ho_tlink
hounding132610053hounding
housing113316523ho_using
hoveling15189593hoveling
hovering151911143hovering
howking183610313ho_wking
howling143413163ho_wling
hugging132710633hug_ging
hunting114317123hunt_ing
hurrying15145533hurrying
hurting113914033hurt_ing
hurtling12318313hurtling
hustling12228793hustling
hutting113016033h_utting
hying126514743h___ying
jettying1933953jettying
jogging173211233jog_ging
joggling18215573joggling
jollying19316053jollying
jolting153410913jolt_ing
jostling16207123jostling
jotting152912773jo_tting
joying173810803jo__ying
juttying1933573juttying
loathing1247673loathing
lobbying1633603lobbying
lofting113311313loft_ing
logging103316803log_ging
looting83019643loot_ing
lotting82917753lo_tting
louting83719383lout_ing
moating104218153moat_ing
mogging123311493mog_ging
molting103517173molt_ing
mooting103019363moot_ing
moseying1436853moseying
mottling11197753mottling
mouthing142810243mouthing
nogging103612723nog_ging
northing12199063northing
nothing113511903no_thing
noting74120153no_t_ing
obeying1336543_obeying
ogling83211883_og_ling
okaying1534833_okaying
opting94514403_opt_ing
outing74128153_out_ing
outlying1248813_outlying
outring84021023_outring
outsing83320463_outsing
outvying1536063_outvying
partying14168893partying
phoneying1844283phoneying
phonying1745833pho_nying
photoing1439073pho_toing
pitying132910243_pitying
ponying133312123po_nying
porting103021783port_ing
posting105622243post_ing
potting103720893po_tting
pouting103519943pout_ing
puttying1434953puttying
retying113213833_retying
rogering10310273rogering
rogueing1054313rogueing
roguing9309563rog_uing
rooting83522433root_ing
rootling9269953rootling
rotting82919683ro_tting
routing83821093rout_ing
shogging14308023shog_ging
shooting122812863shoot_ing
shorting122514803short_ing
shotting123012383sho_tting
shouting122711793shout_ing
soothing12269973soothing
sooting82820963soot_ing
sorting83221813sort_ing
southing122811823southing
stying105414573__stying
toadying1335043toadying
togging103512743tog_ging
toggling11206483toggling
toiting83217093toit_ing
toothing12278863toothing
tooting83019423toot_ing
tootling9279523tootling
toting74123793to_t_ing
totting82816843to_tting
touting84118453tout_ing
toying105017303to__ying
tying96019843___tying
untying1138943_untying
vogueing1332233vogueing
voguing12296093vog_uing
voting103916033vo_t_ing
wonting113214103wont_ing
worrying1534703worrying
worthing15178053worthing
wotting112913843wo_tting

Search took 7 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 Limit1461622106.29623215.1
3Display Results2102100.0932258.1
 (SQL Overall)1786912106.80926243.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.