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

236 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
hornily133828(None) 
cornily12410851cornily
horsily1338841horsily
thornily1444151thornily
bonnily1236872bonnily
cornify1536252cornify
gorily10612502gor_ily
hardily143310272hardily
hoarily1338972hoarily
hokily16409092ho_kily
holily123612952ho_lily
homily144712332ho_mily
hornbill1384172hornbill
hornier103012452hornier
horning113015002horning
hornist102314822hornist
hornito1047072hornito
horny115619622horn__y
horribly16114312horribly
horridly15114782horridly
horrify1635022horrify
loonily1037072loonily
moonily1248942moonily
phonily1537102pho_nily
sorrily1039822sorrily
wordily1437852wordily
aerily93017013aer_ily
airily93014823air_ily
artily92814713_artily
bodily12310993bo_dily
boozily2135623boozily
boringly1438403boringly
bornite9311183bornite
bossily1237563bossily
bouncily1544383bouncily
boxily1877843bo_xily
burlily1237713burlily
cannily1239263cannily
carnify1555883carnify
charily15310283char_ily
chirpily1843773chirpily
choppily2044133choppily
chorally1638103chorally
cockily1838493cockily
cornel84020053cornel_
cornels94716663cornels
cornice11612933cornice
cornicle1258783cornicle
cornier93017083cornier
corning103720123corning
corny106023273corn__y
cosily113613853co_sily
cozily20349703co_zily
curlily1238383curlily
dirtily1138583dirtily
doily95321033do__ily
doomily1336133doomily
dopily123510463do_pily
dornick1435273dornick
dottily1147283dottily
dowdily1534953dowdily
dozily19329103do_zily
drily95816523_dr_ily
eerily92913563eer_ily
foamily1546543foamily
foggily1535053foggily
fondly13299043fo_ndly
forcibly1843863forcibly
fornix1636033forni_x
fortify1636523fortify
foxily1947253fo_xily
funnily1336373funnily
furrily1337603furrily
godlily1235343godlily
goofily14105353goofily
goutily1137933goutily
hammily1736063hammily
handily143610873handily
happily1745763happily
hardly135112833har_dly
harshly1636273harshly
hastily133010663hastily
hazily2179063h_azily
headily1478623headily
heartily1436563heartily
heavily1665903heavily
heftily1635763heftily
hernia9312293herni_a
herniae1039043herniae
hernial10310433hernial
hernias10310773hernias
hoarsely1444363hoarsely
hobnail1243973hobnail_
hobnails1343303hobnails
holly114824433ho__lly
holy106333433ho___ly
homely145313173ho_mely
hominy144511483ho_miny
hondle103914523ho_ndle
honey115629913ho_n_ey
honied104818393ho_nied
honing103421503ho_ning
honkey165113823ho_nkey
honky156218523ho_n_ky
hooly115022223ho__oly
hopingly1735653hopingly
horal86328673hor_al_
horary12310383hor_ary
hording123517053hording
horn76735613horn___
hornbills1493863hornbills
horned105718703horn_ed
hornet94926433horn_et
hornets104113553hornets
hornfels1443783hornfels
horniest112814043horniest
hornings12238363hornings
hornists11208833hornists
hornitos1145393hornitos
hornlike1536503hornlike
hornpipe1542763hornpipe
horns86125333horn__s
horntail11105033horntail_
horntails12124823horntails
horrible13135233horrible
horrid10311553horri_d
horsefly1744873horsefly
horsey125115403hor_sey
horsier103013243horsier
horsing113215583horsing
horsy116318393hor__sy
hostile10312553hostile
hostly124210863ho_stly
hotly115815473ho__tly
hourly12369623ho_urly
huffily1934693huffily
hurly115819293hur__ly
huskily17236333huskily
jerkily2134623jerkily
jointly1735483jointly
jokily20306533jo_kily
jollily1745773jollily
joltily1746323joltily
loftily1336353loftily
logily1039833lo_gily
lonely92912473lo_nely
longly10279603lo_ngly
loopily1236803loopily
lordly1038753lor_dly
lousily1038333lousily
lowlily1335353lowlily
merrily1238633merrily
mirkily16266403mirkily
moodily1358203moodily
morally12411493morally
morbidly1643833morbidly
morning103215043morning
moronity1347333moronity
mortify1536223mortify
mousily1239393mousily
murkily16287113murkily
nervily1336863nervily
nobbily1436693nobbily
noily86120993no__ily
noisily1038403noisily
nonoily1049543nonoily
nosily93712683no_sily
oilily93111723_oilily
oily77932253_o__ily
only75319723_o_n_ly
oozily18328073_oozily
orally93113593_orally
ornery938463_ornery
ornis54616773_orni_s
perkily1637803perkily
pockily1846233pockily
podgily1435213podgily
pokily15309063po_kily
pornier93413123pornier
porny106020193porn__y
portly114713403por_tly
pronely12310243pronely
prosily12611633prosily
punily11311773_punily
pursily1238213pursily
rainily10310433rainily
roily86121113__roily
roomily1237283roomily
ropily113312443ro_pily
rosily93914713ro_sily
roundly1136723roundly
roupily1246653roupily
rowdily1436083rowdily
shinily13268933shinily
shoddily1643563shoddily
shortly13387563shor_tly
showily1636213sho_wily
soapily1237963soapily
soggily1235953soggily
sonly85718053so_n_ly
sootily101810513sootily
sordidly1344663sordidly
sorely94618003sor_ely
sorning83116813sorning
soundly1136683soundly
spoonily1335233spoonily
sportily1337733sportily
stonily1049433stonily
stormily1345243stormily
sunnily1037833sunnily
surlily1039993surlily
tardily11269583tardily
tartily103511573tartily
tawnily1335443tawnily
thornier1135323thornier
thorning1237513thorning
thorny12509843thorn__y
tinily94014433_tinily
tinnily1047363tinnily
tornillo854623tornillo
torpidly1483643torpidly
torridly1284463torridly
torrify1335013torrify
tortile7313193tortile
verily122616053ver_ily
warily122915093war_ily
wirily123310783wir_ily
woozily2234383woozily
worldly1433973worldly
wormil1138043wormil_
wormils1236733wormils
worthily1745253worthily
wrongly1434553wrongly
zanily18310183_zanily
zoril143916693zor_il_
zorils153810883zor_ils

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 Filter1786911340270.233766914.2
2DLD Change Limit1340272367.84617082.2
3Display Results2362360.0932537.6
 (SQL Overall)1786912368.17221866.3
 
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.