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

165 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
dehorned134568(None) 
dehorner1235521dehorner
dehorted1357301dehorted
bethorned1544442bethorned
deboned113411632debo_ned
decerned1237262decerned
deforced15247372deforced
deformed15248262deformed
dehorn10439652dehorn__
dehorners1344742dehorners
dehorns11428362dehorn_s
deponed113712872depo_ned
deported1249702deported
desorbed1236432desorbed
dethroned1445072dethroned
dewormed15236222dewormed
horned105718702__horned
thorned11479402_thorned
abhorred1443493abhorred
acorned10238263_acorned
adorned9256883_adorned
attorned955353attorned
behooved1743133behooved
behoved16205563beho_ved
behowled1733463behowled
bemoaned1335553bemoaned
bewormed16235443bewormed
chorded144710553_chorded
chored125321883_chor_ed
churned13358373_churned
corned95224523__corned
darned85018483d__arned
deaconed1237493deaconed
deadened1137233deadened
deafened1335853deafened
deaired9411533deair_ed
deaned84620453de__aned
debarked16175823debarked
debarred12165633debarred
debone93714783debo_ne_
deboner103110483debo_ner
debones103315113debo_nes
declined123910883declined
decocted1437683decocted
decoded123212383deco_ded
decorated13312203decorated
decoyed14358333deco_yed
decreed112710253de_creed
decried112612853de_cried
decrowned1663653decrowned
decurved1534843decurved
deepened1235653deepened
deferred13106363deferred
defined123813823de_fined
defoamed15356243defoamed
defogged1533783defogged
deforce13267243deforce_
deforcer14246903deforcer
deforces14248403deforces
deformer14247943deformer
degermed1335453degermed
degreed10258883de_greed
dehisced1583683dehisced
dehorning1455243dehorning
dehort104618103dehor__t
dehorts11379773dehor_ts
deigned1037503de_igned
deloused1036973deloused
demarked16187223demarked
demeaned1237283demeaned
demerged13157603demerged
demobbed1643203demobbed
demoded123611123demo_ded
demoed103713443demo__ed
demoted114313543demo_ted
demounted1344903demounted
demurred1234933demurred
denned84215633de__nned
denoted93512763deno_ted
denounced1344033denounced
departed1238823departed
depermed1436453depermed
deplaned1238653deplaned
deplored1237223deplor_ed
depone93616553depo_ne_
depones103717093depo_nes
deportee11510353deportee
deporter1169393deporter
deposed113412023depo_sed
descried1248073descried
deserted101012203deserted
deserved13108133deserved
designed1136943designed
desired9311983desir_ed
destined103312453destined
detained103111643detained
deterged11127923deterged
deterred10137803deterred
dethrone1247563dethrone_
dethroner1344483dethroner
dethrones1347313dethrones
detoured1036513detoured
detoxed1636103deto_xed
deveined1336673deveined
devoiced15276063devoiced
devolved16325513devolved
devoted124111093devo_ted
devoured1335723devoured
dewooled1333833dewooled
dewormer14256323dewormer
disowned1336433disowned
divorced1544313divorced
donned85015743d__onned
downed115314783d__owned
droned84616863d_ro_ned
drowned12419903d_rowned
durned84113173d__urned
earned74818333_e_arned
eloined8149813_eloined
exhorted1935013exhorted
honed95332263__ho_ned
horded115420483__horded
hornet94926433__hornet
horsed105321083__horsed
kerned114112923ke__rned
learned8329303le_arned
neoned7311483ne_o_ned
phoned124014553_pho_ned
readorned1145183readorned
rebored105015883rebor_ed
recoined113614423recoined
reconned113610653reconned
recorded122511063recorded
recorked15239853recorked
redonned10297103redonned
reearned948883reearned
reforged13268703reforged
reformed14249603reformed
regorged11227333regorged
rehired115013153rehir_ed
rehoused1239613rehoused
rejoined16318593rejoined
reloaned939723reloaned
renowned1235973renowned
reported11312703reported
resorbed1138523resorbed
resorted9313493resorted
retorted9312333retorted
returned9459133returned
reworded13228103reworded
reworked16247773reworked
rezoned173611163rezo_ned
scorned10229953_scorned
secerned1136103secerned
shoehorned1751653shoehorned
shored105723643_shor_ed
shorted113614393_shorted
sorned74820043__sorned
suborned1137293suborned
tenoned839363teno_ned
throned115412173_throned
unhorsed1238833unhorsed
whored135512123_whor_ed
whorled14366903_whorled
yearned11327373ye_arned

Search took 10 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.296603685.8
2DLD Change Limit1461621659.20315882.0
3Display Results1651650.0802062.5
 (SQL Overall)1786911659.57918654.5
 
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.