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

144 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
spermic133852(None) 
dermic114511912_dermic
permit10321682_permit
sapremic1445332sapremic
sperm93216022sperm__
spermatic1548712spermatic
spermine12311432spermine
sperms102512602sperm_s
spheric14510072spher_ic
steric8317062ster_ic
thermic1439332thermic
acerbic1335643acerbic
anemic102713693ane_mic
anergic1048103anergic
aspheric1547983aspher_ic
ceramic1339823_ceramic
ceric94023093_cer_ic
chemic153012093che_mic
cleric10612133cler_ic
copremic1645453copremic
demic105119193_de_mic
dermis94717163_dermis
dharmic1535013dharmic
emic86422753__e_mic
endermic1356173endermic
epeiric1145313epeiric
epidermic1643753epidermic
fermi103914163_fermi_
fermis114313503_fermis
ferric1139993_ferric
formic13310453_formic
haemic133210083hae_mic
hemic125718623_he_mic
herdic123112303_herdic
hermit11519443_hermit
heroic113516923_heroic
hyperemic2146893hyperemic
karmic1438113_karmic
keramic1537233_keramic
kermis124012393_kermis
neumic1036853_neumic
operatic1249933operatic
overmix1935573overmix
pectic122913873_pectic
pelvic13307553_pelvic
peptic122113153_peptic
perdie94718513_perdie
pereia85217983_pereia
peri65636973_per_i_
peril75425953_per_il
peris75537073_per_is
perm85834633_perm__
permed115217353_permed
permian112612283_permian
perming123416093_perming
permits11314003_permits
perms95524513_perm_s
pernio8513143_pernio
premie103617993_premie
premix173710333_premix
psalmic1345333psalmic
pyemic1537893_pyemic
pyric123815073_pyr_ic
rheumic1443543rheumic
sapremia1245203sapremia
scenic10510513sce_nic
sceptic1337833sceptic
seismic1145753seismic
sememic1336503sememic
semi65127223s_e_mi_
semis74623533s_e_mis
sepic94617053s_e_pic
septic102713193s_eptic
serac75925203s_er_ac
serai56830163s_erai_
serail64222673s_erail
serais64326133s_erais
serein63318463s_erein
serif84132133s_er_if
serin55434443s_er_in
sermon8413553s_ermon
sermonic1248883s_ermonic
service1239083s_ervice
sferics1236133sfer_ics
sherif122915243sher_if
sherris10168803sherris
skeptic1545203skeptic
smectic1336613smectic
sorbic10310393s_orbic
sparid94016933spar_id
sparoid102311543sparoid
spastic11310383spastic
spathic1437543spathic
spearman1244943spearman
spearmen1234853spearmen
spearmint1365983spearmint
spec85821973spe___c
specie10412223spe_cie
specific1744703specific
speil75618643spe__il
speir75315363spe__ir
spermary1545043spermary
spermatia1346743spermatia
spermatid1448043spermatid
spermicide1753493spermicide
spermines13310543spermines
spermous1247933spermous
sphenic1449093sphenic
spherics1537073spher_ics
spheroid1447283spheroid
sphygmic2141973sphygmic
spic85227433sp___ic
spirit83519923spir_it
spiroid10219823spiroid
splenic1148663splenic
sporadic1345053sporadic
sporoid102310733sporoid
sportif1238803sportif
sprain83614863sp_rain
sprig85617743sp_r_ig
sprit76736403sp_r_it
stearic939423stearic
stelic8313083ste_lic
steroid81314863steroid
suberic11312213suber_ic
superchic1846393superchic
superfix2045463superfix
superhit13410503superhit
superlie10312123superlie
superman12310233superman
supermen12311303supermen
supermicro1653893supermicro
supermind1449043supermind
supermini1348953supermini
supermom1446993supermom
superrich1647083superrich
synergic1444313synergic
terbic10410963_terbic
thermit12312013thermit
uremic103410513ure_mic
vermin113414523_vermin
vermis114214963_vermis
viremic1436153viremic
xeric144315663_xer_ic

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271447.22018563.3
3Display Results1441440.0463130.4
 (SQL Overall)1786911447.67223291.3
 
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.