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

177 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
simonies1031111(None) 
simonizes2047821simonizes
alimonies1198332alimonies
ironies7517422_ironies
limonites1148002limonites
monies83233162__monies
saxonies1537912saxonies
simoniac1245342simoniac
simoniacs1343712simoniacs
simonist10410722simonist
simonists1146762simonists
simonize1947802simonize
simonized2146512simonized
spoonies101911752spoonies
acrimonies1445043acrimonies
agonies83016623_agonies
agrimonies1343403agrimonies
alimonied1284843alimonied
almonries1156923almonries
ammonias1247943ammonias
ammonites1348133ammonites
antimonies12410583antimonies
armories10313653armories
astonies8815093astonies
atonies75320953_atonies
baronies10315023baronies
betonies10413063betonies
bionics114310873bi_onics
bizones1837823bizon_es
boonies93422483_boonies
brionies10310543brionies
bryonies1336843bryonies
ciphonies1646533ciphonies
colonies103620013colonies
conies84338593__conies
cronies9622503_cronies
daimones11208803daimon_es
demonise11411933demonise
demonises12311093demonises
demonizes21311063demonizes
dimities11314003dimities
dipodies1238413dipodies
dominies113513193dominies
ebonies9312883_ebonies
eikones1137853eikon_es
felonies11310993felonies
gimmies123010113gim_mies
goonies83618333_goonies
harmonies141311043harmonies
hinnies103615103hi_nnies
hominies133012953hominies
icones84616383_icon_es
imbodies1345483_imbodies
imines84918353_imin_es
immies102412443_im_mies
implies11312123_implies
impones112712253_impon_es
ionics84214483_i_onics
ionise63516943_i_onise
ionises72916433_i_onises
ionizes162813343_i_onizes
irones64724013_iron_es
ironizes17510373_ironizes
isogonies10207263isogonies
ivories10310713_ivories
jimmies18328783jim_mies
kimonoed1542803kimonoed
kimonos13114633kimon_os
limonenes1144983limonenes
limonite1048163limonite
lionise7310373li_onise
lionises8310313li_onises
lionizes1738773li_onizes
litanies8310993litanies
loonies73919543_loonies
memories121214343memories
minnies93617363mi_nnies
molies84429513__molies
mondes94322353__mondes
monie75631653__monie_
monied94319463__monied
montes84226933__montes
movies115118453__movies
moxies154317403__moxies
ninnies73713613ni_nnies
palimonies1445633palimonies
parsimonies1553403parsimonies
peonies93620153_peonies
phonies123717513_phonies
pinnies93318443pi_nnies
pinones94717073pinon_es
pirogies1139423pirogies
ponies84833463__ponies
salmonids1245543salmonids
sanies63031953s__anies
saponines1148043saponines
saponins1039453saponins
saponites1139933saponites
savories11311273savories
scammonies1643723scammonies
sconces113811453s_conces
scones84521303s_con_es
secondes1138133secondes
sermonizes21148363sermonizes
shannies113411253shannies
sheenies111411543sheenies
shimmies15287803shim_mies
shinnies113010913shinnies
shmoes114612093shmo__es
shmoozes22254863shmoozes
sickies133717503si_ckies
sicklies14710013sicklies
sienites8311913si_enites
siganids1045303siganids
sigmoids1244453sigmo_ids
signees83510803si_gnees
signories10107853signories
silanes72517163silan_es
silences10310073silences
silkies113715693si_lkies
sillies73425073si_llies
simazines2044863simazines
similes92915233sim_iles
simlins9311833sim_lins
simnel857023sim_n_el
simnels976103sim_nels
simony1137903simon__y
simooms1135573simo_oms
simoons937933simo_ons
simples113014943sim_ples
simplices1546043simplices
sines55954823si__n_es
sinfonias1244313sinfonias
sinfonie1145253sinfonie_
singes74326853si__nges
sinopias1047863sinopias
sinopie948773sinopie_
sissies73716603si_ssies
sixties14310973si_xties
skimobiles1851993skimobiles
smithies1337913smithies
smokes124814343s_mo_kes
smokier1356703s_mokier
smokiest1437883s_mokiest
sodomies11128553sodomies
someones1039063someon_es
somoni8310733somoni__
sondes74922873s__ondes
sones55444143s__on_es
sonics84315633s__onics
sonnies7315223s_onnies
spinnies103210543spinnies
sponges10311043s_ponges
spoonier10167653spoonier
spooniest11178133spooniest
spumones1254953spumon_es
spumonis1264113spumoni_s
stimies9316553stim__ies
stogies8413693s_togies
stones65130033s_ton_es
stonier72013793s_tonier
stoniest8413543s_toniest
stoolies8311083stoolies
stories7324273s_tories
stramonies1246633stramonies
summonses1344533summonses
sweenies11148763sweenies
swoonier11185133swoonier
swooniest12176293swooniest
symphonies2046113symphonies
syntonies1248153syntonies
testimonies1352693testimonies
timothies1444713timothies
toonies73719883_toonies
twoonies1155693twoonies
wicopies1545983wicopies
wienies102213683wi_enies

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 Filter1786911461620.1731032896.0
2DLD Change Limit1461621777.62319173.8
3Display Results1771770.0802212.5
 (SQL Overall)1786911777.87622688.0
 
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.