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

212 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
pianism1161103(None) 
pianisms1249011pianisms
pianist9615101pianist
giantism1155382giantism
nanism8311202_nanism
onanism9310132onanism
paeanism1248702paeanism
paganism1369112paganism
papism122211512p_apism
peonism11611102peonism
pianic103714122piani_c
pianists1049012pianists
pianos84315932pianos_
pians75126962pian_s_
pietism1139112pietism
planish12412052planish
plenism11310112plenism
priapism1456242priapism
titanism1048212titanism
uranism91112512uranism
agism84614063__agism
alienism1047733alienism
alpinism1286183alpi_nism
anis45746463__anis_
anise55129703__anise
apiarist10412053apiarist
atavism1238033atavism
baalism11310593baalism
banish111416043_banish
bialis83617163bialis_
binarism1248353binarism
charism14712203charism
civism1337243ci_vism
cladism1238553cladism
clonism1138983clonism
cranium11911103cranium
czarism2056423czarism
danish101513793_danish
dialist8517763dialist
diarist8517113diarist
dualism1049163dualism
eonism83213533_eonism
epicenism1545103epicenism
epigonism1445163epigonism
epizoism2163513epizoism
etatism9610293etatism
evanish1337653evanish
favism1437913_favism
fideism1335773fideism
finalism133010363finalism
finis86824263fi_nis_
finish124613413fi_nish
giantisms1244813giantisms
giants74713503giants_
gigantism1343373gigantism
hispanism1643533hispanism
humanism1548093humanism
imagism1285083imagism
iodism93611133_iodism
ionise63516943_ionise
ionium8610923_ionium
jinnis13489053jinnis_
kiangs11378363kiangs_
kyanise14236143kyanise
laicism1138243laicism
liaise6310693lia_ise
lianas63713383lianas_
lianes63819323lianes_
liangs74410593liangs_
lionise7310373lionise
melanism1239363melanism
miasm91211093mia__sm
minim97321603mi_ni_m
minims104514813mi_nims
minis75432993mi_nis_
minish115216303mi_nish
minium106014423mi_nium
monism104016313_monism
nanisms938833_nanisms
onanisms1048063onanisms
onanist7314633onanist
opiumism1442893opiumism
oralism9513763oralism
organism1148393organism
padis86227143p_adis_
paeanisms1347583paeanisms
paganise1139663paganise
paganish1447773paganish
paganisms1447933paganisms
paganist11411813paganist
paining103920243paining
pains75138283pain_s_
paints85921833paints_
paisa76021073p_a_isa
paise75028333p_a_ise
palish114718273p_alish
panes76148693p_anes_
panfish15229973p_anfish
pangs84628663p_angs_
panic93923903p_ani_c
panics103815363p_anics
panicum1346393p_anicum
panier84425503p_anier
panini8314273p_anini
panino8315683p_anino
pans65855733p_an_s_
pansy105717973p_an_sy
pants76536923p_ants_
papisms13238543p_apisms
papist102618743p_apist
paris75145943p_aris_
parish115022353p_arish
passim10410283p_assim
pavis106422733p_avis_
pavise114714803p_avise
paynim1337363payni_m
paynims1434973paynims
peakish16268873peakish
peans75437643pean_s_
penis75129323p_enis_
pennis84315743pennis_
peonisms1238443peonisms
phallism1545713phallism
phantasm1554133phantasm
phantom1436693phantom
phasis114614923phasis_
pian66136093pian___
pianissimi1451173pianissimi
pianissimo1451323pianissimo
pianistic1347173pianistic
piano76118713pian__o
pias66542553pia__s_
picnic123410263picni_c
picnics13297343picnics
pietisms1247463pietisms
pietist9414033pietist
pigfish16217173pigfish
piggish14227703piggish
pignus937953pignus_
pikis115116393pi_kis_
pilis75825203pi_lis_
pinangs10267793pinangs_
pinas75434453pi_nas_
pines76048863pi_nes_
pinfish15319303pinfish
pings85830883pi_ngs_
pinier84024693pi_nier
piniest93121133pi_niest
pining93726533pi_ning
pinion83815893pi_nion
pinite8321243pi_nite
pinkish16279113pinkish
pinks115729383pi_nks_
pinnas85315513pinnas_
pinnies93318443pinnies
pinning103417853pinning
pins65558453pi_n_s_
pints75936223pi_nts_
pionic103515953pioni_c
pions75826393pion_s_
piranas9912603piranas_
pirns76020093pirn_s_
pixyish2253653pixyish
plains85019593plains_
planes85028083planes_
planing103418253planing
planks124116753planks_
plans75731273plan_s_
plants84921803plants_
plasm94114633pla__sm
platonism1397543platonism
plenish1239943plenish
plenisms1237963plenisms
plenist9314333plenist
porism104518063p_orism
praise84419413pra_ise
prangs94816233prangs_
prankish1737023prankish
pranks124814723pranks_
praxis154012253praxis_
priapisms1545463priapisms
priggism1444383priggism
prism94820263p__rism
privatism16176933privatism
ptyalism15115793ptyalism
punish111411503p_unish
purism104715063p_urism
puritanism1454613puritanism
racism103214193_racism
ranis55235833_ranis_
realism93115923realism
sadism94113493_sadism
satanism1039673satanism
sinapism1245573sinapism
statism9412283statism
tanist6324593_tanist
titanisms1147423titanisms
titanium1046033titanium
triadism1147553triadism
tsarism958253tsarism
tzarism1866323tzarism
unionism1047013unionism
uranisms1099973uranisms
uranium9610023uranium
urbanism12107213urbanism
utopianism1452583utopianism
vanish121513213_vanish
veganism1446443veganism
viands1047813viands_
vitalism1339683vitalism
winish124212263wi_nish
womanism1548113womanism

Search took 7 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 Limit1340272126.01622278.4
3Display Results2122120.0762789.5
 (SQL Overall)1786912126.49827499.4
 
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.