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

269 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
pianist961510(None) 
pianism11611031pianism
pianists1049011pianists
apiarist10412052apiarist
dialist8517762dialist
diarist8517112diarist
onanist7314632onanist
paganist11411812paganist
papist102618742p_apist
pianic103714122piani_c
pianisms1249012pianisms
pianistic1347172pianistic
pianos84315932pianos_
pians75126962pian_s_
pietist9414032pietist
piniest93121132pi_niest
planish12412052planish
plenist9314332plenist
tanist6324592_tanist
against838383against
agist66325583__agist
agonist82615403agonist
alienist8411993alienist
alist56136783__alist
alpinist1059153alpi_nist
angst6415493__angst
anis45746463__anis_
anise55129703__anise
apiarists1147883apiarists
atavist10311093atavist
aviarist11410113aviarist
banish111416043_banish
bialis83617163bialis_
biblist11310833biblist
bigamist1347063bigamist
binit76431583bi_ni_t
binits85716673bi_nits
botanist10412033botanist
canst74932213_can_st
cladist10311973cladist
czarist18710223czarist
danish101513793_danish
dialists9411413dialists
diallist949553diallist
diarists9410363diarists
digamist1248213digamist
dualist8614053dualist
epigenist1247933epigenist
etatist7415033etatist
evanish1337653evanish
fainest10417703fainest
fideist1139753fideist
finalist113014733finalist
finest94321733fi_nest
finis86824263fi_nis_
finish124613413fi_nish
finniest113011403finniest
gainst74914693gain_st
giant65430593gian__t
giantism1155383giantism
giants74713503giants_
ginniest92610513ginniest
hornist102314823hornist
humanist13410493humanist
hymnist1546633hymnist
imagist1077333imagist
inanest72115363inanest
insist6314513_insist
ionise63516943_ionise
ironist7314843ironist
jinnis13489053jinnis_
kainit10414483kaini_t
kainits1137763kainits
kiangs11378363kiangs_
kyanise14236143kyanise
leanest7415863leanest
liaise6310693lia_ise
lianas63713383lianas_
lianes63819323lianes_
liangs74410593liangs_
liniest73321153li_niest
lionise7310373lionise
lutanist8410273lutanist
maist75535683_ma_ist
meanest9315703meanest
melanist10313053melanist
midlist10312513midlist
minis75432993mi_nis_
minish115216303mi_nish
monist84324983_monist
nanism8311203_nanism
onanism9310133onanism
onanists838413onanists
oralist7619633oralist
organist9411543organist
paciest112917803p_aciest
padis86227143p_adis_
paeanism1248703paeanism
paganise1139663paganise
paganish1447773paganish
paganism1369113paganism
paganists1247643paganists
paining103920243paining
pains75138283pain_s_
paint75443693p_a_int
paintiest11310563paintiest
paints85921833paints_
paisa76021073p_a_isa
paise75028333p_a_ise
palest83926223p_alest
paliest93021603p_aliest
palish114718273p_alish
palmist112814343palmist
pandit93820753p_andit
pandits103914213p_andits
panelist10414503p_anelist
panes76148693p_anes_
panfish15229973p_anfish
pangs84628663p_angs_
panic93923903p_ani_c
panics103815363p_anics
panier84425503p_anier
panini8314273p_anini
panino8315683p_anino
pans65855733p_an_s_
pansy105717973p_an_sy
pant66061263p_an__t
pants76536923p_ants_
papism122211513p_apism
papists112110453p_apists
paris75145943p_aris_
parish115022353p_arish
past65959013p_a__st
pavis106422733p_avis_
pavise114714803p_avise
peakiest143512993peakiest
peakish16268873peakish
peans75437643pean_s_
peanut8318183pean_ut
peanuts936993peanuts
peatiest103118803peatiest
penis75129323p_enis_
pennis84315743pennis_
peonism11611103peonism
persist9315853persist
phallist1338983phallist
phantast1346923phantast
phasis114614923phasis_
phoniest132811533phoniest
pian66136093pian___
piano76118713pian__o
pias66542553pia__s_
pickiest162712593pickiest
picnic123410263picni_c
picnics13297343picnics
pietism1139113pietism
pietists1038323pietists
pigfish16217173pigfish
piggiest12259663piggiest
piggish14227703piggish
pignus937953pignus_
pignut9311573pign_ut
pignuts1035613pignuts
pikis115116393pi_kis_
pilis75825203pi_lis_
pinangs10267793pinangs_
pinas75434453pi_nas_
pines76048863pi_nes_
pinfish15319303pinfish
pings85830883pi_ngs_
pinier84024693pi_nier
pining93726533pi_ning
pinion83815893pi_nion
pinite8321243pi_nite
pinkest132812623pinkest
pinkish16279113pinkish
pinks115729383pi_nks_
pinnas85315513pinnas_
pinnies93318443pinnies
pinning103417853pinning
pinot78737293pi_n_ot
pinots85920273pi_nots
pins65558453pi_n_s_
pint66963173pi_n__t
pints75936223pi_nts_
pionic103515953pioni_c
pions75826393pion_s_
pipiest113114493pipiest
pipit95224873pi_pi_t
pipits104713063pi_pits
piranas9912603piranas_
pirns76020093pirn_s_
pithiest132711443pithiest
pixyish2253653pixyish
plainest10313613plainest
plains85019593plains_
plaint85323203pla_int
plaints94012053plaints
plait75631573pla_i_t
plaits83816473pla_its
planes85028083planes_
planet84228353plan_et
planets93914083planets
planing103418253planing
planks124116753planks_
plans75731273plan_s_
plant75437113plan__t
plants84921803plants_
platiest103216083platiest
playlist1347573playlist
plenish1239943plenish
plenism11310113plenism
plenists1038253plenists
pliant83918823plian__t
pollist9816603pollist
poloist91016323poloist
porniest103214313porniest
praise84419413pra_ise
prangs94816233prangs_
prankish1737023prankish
pranks124814723pranks_
praxis154012253praxis_
priapism1456243priapism
privatist14228783privatist
protist9320223protist
psalmist1276353psalmist
puniest92918093p_uniest
punish111411503p_unish
punniest102511583punniest
purist85525053p_urist
racist82822793_racist
rainiest81214923rainiest
ranis55235833_ranis_
rapist82520673_rapist
realist73225383realist
riant55833153rian__t
sadist74221353_sadist
sanest64426693_sanest
satanist8313363satanist
simonist10410723simonist
sitarist8315283sitarist
spiniest102813223spi_niest
statist7317723statist
tanists7313653_tanists
tennist72813113tennist
timpanist1345373timpanist
tiniest73020123ti_niest
tinniest82911463tinniest
titanism1048213titanism
titlist7312923titlist
transit7317163transit
tsarist7712253tsarist
tzarist1659103tzarist
unionist8410353unionist
uranism91112513uranism
urbanist10109073urbanist
vainest10315763vainest
vanish121513213_vanish
viands1047813viands_
vibist11610583vi_bist
viniest103216613vi_niest
violist10312143violist
vitalist11313393vitalist
waist86132383_wa_ist
waniest103819113_waniest
winiest103419693wi_niest
winish124212263wi_nish
womanist13410433womanist
zaniest163214773_zaniest

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.423422437.4
2DLD Change Limit1340272695.96622465.1
3Display Results2692690.0962802.1
 (SQL Overall)1786912696.48527554.5
 
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.