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

179 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
dehorting144721(None) 
dehorning1455241dehorning
deporting1369591deporting
decocting1538122decocting
decorating14312072decorating
deforcing1636062deforcing
deforming1636702deforming
demoting12311422demo_ting
denoting10311752deno_ting
departing1349512departing
deserting11713142deserting
desorbing1346362desorbing
devoting1338822devo_ting
deworming1635042deworming
exhorting2045732exhorting
reporting12513902reporting
resorting10614612resorting
retorting10613272retorting
shorting122514802_shorting
abhorring1543543abhorring
aborting11710253_aborting
assorting1037303assorting
beholding1634233beholding
behooving1843743behooving
behoving1734913beho_ving
behowling1843683behowling
beshouting1644023beshouting
besotting12256873besotting
bethorning1644203bethorning
beworming1734553beworming
cavorting1536063cavorting
charting142614193_charting
chording15410153_chording
choring133617663_chor_ing
chortling1535563_chortling
cohosting1546323cohosting
darting94020663d__arting
deaerating12311563deaerating
deairing10311893deair_ing
debarking1735383debarking
debarring1335713debarring
debating123213733de_bating
debiting122511203de_biting
deboning12109153debo_ning
debuting12268633de_buting
decanting132510633decanting
decerning1337293decerning
decoding132410053deco_ding
decoying15208763deco_ying
decrying15237413de_crying
decurving1634723decurving
deducting1436843deducting
defatting1436103defatting
defeating142311973defeating
defecting162510223defecting
deferring1436143deferring
deflating142610713deflating
defoaming1645653defoaming
defogging1653863defogging
deforesting1654793deforesting
defrosting1544493defrosting
degerming1435753degerming
degusting1236163degusting
dehiscing1643733dehiscing
dehorn10439653dehor__n_
dehorns11428363dehor__ns
dehort104618103dehort___
dehorted1357303dehort_ed
dehorts11379773dehort__s
dehydrating2043653dehydrating
dejecting20217793dejecting
delating103119603de_lating
deleting103314423de_leting
delisting112710503delisting
delousing1136303delousing
demarking1736773demarking
demasting1338453demasting
dementing13311043dementing
demerging1436643demerging
demeriting1448683demeriting
demitting13239073demitting
demobbing1743493demobbing
demoing11311753demo__ing
demounting1444963demounting
demurring1335253demurring
denting94422183de__nting
deorbiting1445153de_orbiting
deperming1537113deperming
depicting1537813depicting
depleting1378193depleting
deploring1337853deplor_ing
deponing121211213depo_ning
deposing12129773depo_sing
depositing1446933depositing
depurating1438643depurating
deputing12238793de_puting
derating103222283de_rating
deratting1139513deratting
derogating1348633derogating
desalting1138843desalting
descrying1635103descrying
deserving1497903deserving
desiring10312143desir_ing
desisting112810383desisting
desolating1239463desolating
despiting13179323despiting
detecting13259983detecting
deterging1237853deterging
deterring1138623deterring
detesting112610323detesting
dethroning1544743dethroning
detonating1248823detonating
detouring1136973detouring
detoxing1736313deto_xing
devesting14249903devesting
deviating14311083deviating
devoicing16145223devoicing
devolving1733983devolving
devouring1435953devouring
dewooling1444323dewooling
disporting1439823disporting
distorting1239583distorting
diverting142410333diverting
divorcing1644323divorcing
doating93816863d__oating
doting84821913d__o_ting
dotting93314483d__otting
emoting10313563_emo_ting
escorting1237713escorting
everting122213133_everting
exerting162211153_exerting
exporting1937323exporting
extorting1746763extorting
ghosting1336463_ghosting
hearting12513123he_arting
hooting113919883__hooting
hording123517053__hording
horning113015003__horning
horsing113215583__horsing
hosting114318383__hosting
hotting113116523__hotting
hurting113914033__hurting
importing1438193importing
intorting10311413intorting
perorating13313133perorating
porting103021783__porting
presorting1339983presorting
rebooting12139023rebooting
reboring11312783rebor_ing
recharting1637213recharting
recoating121317463recoating
recording131311623recording
recorking16149643recorking
reforging1437663reforging
reforming1538563reforming
regorging1236823regorging
reheating132314913reheating
rehiring122911883rehir_ing
rehousing1337253rehousing
repotting12511123repotting
rerouting10311873rerouting
reshooting1436223reshooting
resorbing1269353resorbing
reverting132315133reverting
revolting1339633revolting
revoting12312033revo_ting
rewording14158543rewording
reworking17136873reworking
shirting123213613_shirting
shooting122812863_shooting
shoring112820073_shor_ing
shotting123012383_shotting
shouting122711793_shouting
snorting92613373_snorting
sorting83221813__sorting
sporting112415463_sporting
thorning1237513_thorning
unhorsing1336853unhorsing
whoring142910293_whor_ing

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 Filter1786911486410.453394461.4
2DLD Change Limit1486411797.26620457.1
3Display Results1791790.0931924.7
 (SQL Overall)1786911797.81222873.9
 
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.