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

215 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
dehorted135730(None) 
dehorned1345681dehorned
deported1249701deported
decocted1437692decocted
decorated13312212decorated
deforced15247372deforced
deformed15248262deformed
dehorner1235522dehorner
dehort104618102dehort__
dehorts11379772dehort_s
demoted114313542demo_ted
denoted93512762deno_ted
departed1238822departed
deportee11510352deportee
deporter1169392deporter
deserted101012202deserted
desorbed1236442desorbed
devoted124111092devo_ted
dewormed15236222dewormed
exhorted1935012exhorted
reported11312702reported
resorted9313492resorted
retorted9312332retorted
shorted113614402_shorted
abhorred1443503abhorred
aborted10310423_aborted
assorted956603assorted
bedotted1234983bedotted
behooved1743133behooved
behoved16205563beho_ved
behowled1733473behowled
beshouted1544073beshouted
besotted1135843besotted
bethorned1544443bethorned
bewormed16235443bewormed
cavorted1435693cavorted
charted135116853_charted
chorded144710553_chorded
chored125321883_chor_ed
chorten122811303_chorten
chortled14326613_chortled
cohosted1436143cohosted
darted84620923d__arted
deaerated11311123deaerated
deaired9411533deair_ed
dealated103213603dealated
debarked16175833debarked
debarred12165643debarred
debated113916083de_bated
debited113311623de_bited
deboned113411633debo_ned
debuted11379333de_buted
decanted122310493decanted
decerned1237263decerned
decoded123212393deco_ded
decorate11315193decorate_
decorates12314743decorates
decoyed14358343deco_yed
decreed112710263de_creed
decried112612863de_cried
decurved1534843decurved
deducted1356243deducted
defatted1335673defatted
defeated132812163defeated
defected15289973defected
deferred13106363deferred
deflated133412303deflated
defoamed15356243defoamed
defogged1533783defogged
deforce13267243deforce_
deforcer14246903deforcer
deforces14248403deforces
deforested1543853deforested
deformer14247943deformer
defrosted1444263defrosted
degermed1335453degermed
degreed10258883de_greed
degusted1135733degusted
dehisced1583683dehisced
dehorn10439653dehor__n
dehorners1344743dehorners
dehorns11428363dehor_ns
dehorting1447213dehorting
dehydrated1943493dehydrated
dejected19307593dejected
delated93722873de_lated
deleted93314913de_leted
delisted10310563delisted
deloused1036983deloused
demarked16187223demarked
demasted1238763demasted
demented12311273demented
demerged13157603demerged
demerited1339073demerited
demitted12288773demitted
demobbed1643203demobbed
demoded123611123demo_ded
demoed103713443demo__ed
demote94817803demo_te_
demotes104717673demo_tes
demounted1344903demounted
demurred1234933demurred
denote74118043deno_te_
denotes83817003deno_tes
dentated10411703dentated
dented84120513de__nted
deorbited1343983de_orbited
departee1139733departee
depermed1436453depermed
depicted1437743depicted
depleted12258723depleted
deplored1237233deplor_ed
deponed113712873depo_ned
deport94922393deport__
deportees1256643deportees
deporters1277793deporters
deports105012883deport_s
deposed113412033depo_sed
deposited1346783deposited
depurated1338183depurated
deputed114610173de_puted
derated93623503de_rated
deratted1048403deratted
derogated1238683derogated
desalted1038313desalted
descried1248083descried
deserter91211603deserter
deserved13108133deserved
desired9311983desir_ed
desisted1039783desisted
desolated1139653desolated
despited1248323despited
detected12289733detected
deterged11127923deterged
deterred10137803deterred
detested10279623detested
dethroned1445073dethroned
detonated1138213detonated
detoured1036513detoured
detoxed1636103deto_xed
devested13239133devested
deviated13311043deviated
devoiced15276063devoiced
devolved16325513devolved
devote104513783devo_te_
devotee113811823devo_tee
devotes113713753devo_tes
devoured1335723devoured
devouter1235513devouter
dewooled1333833dewooled
dewormer14256323dewormer
disported13310303disported
distorted1139373distorted
diverted13199583diverted
divorced1544313divorced
doated84118183d__oated
doited85016633d__oited
doted75227073d__o_ted
dotted84717523d__otted
emoted94614923_emo_ted
escorted1136703escorted
everted112711853_everted
exerted152210053_exerted
exhorter1845353exhorter
exported1837133exported
extorted1636233extorted
ghosted1236273_ghosted
hearted113314033he_arted
hooted104422663__hooted
horded115420483__horded
horned105718703__horned
horsed105321083__horsed
hosted105020343__hosted
hotted104319943__hotted
imported13308693imported
intorted9310123intorted
perorated12412473perorated
ported94223243__ported
presorted1239453presorted
rebooted11248463rebooted
rebored105015883rebor_ed
recharted1557563recharted
recoated113416793recoated
recorded122511073recorded
recorked15239863recorked
reforged13268703reforged
reformed14249603reformed
regorged11227333regorged
reheated122415003reheated
rehired115013153rehir_ed
rehoused1239623rehoused
reporter10411423reporter
repotted1139283repotted
rerouted9311153rerouted
resorbed1138533resorbed
resorter8312183resorter
retorter8410733retorter
reverted122714713reverted
revolted12319863revolted
revoted114314153revo_ted
reworded13228103reworded
reworked16247773reworked
shored105723653_shor_ed
shorten103511413_shorten
shorter103515503_shorter
shotted113912403_shotted
shouted113911553_shouted
snorted83813493_snorted
sorted74523713__sorted
sported104015433_sported
thorned11479403_thorned
unhorsed1238833unhorsed
unsorted9312513unsorted
whored135512123_whor_ed
whorled14366903_whorled

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.500357382.0
2DLD Change Limit1461622157.70318974.7
3Display Results2152150.0932311.8
 (SQL Overall)1786912158.29621539.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.