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

207 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
charisms1571026(None) 
charism14712201charism_
charisma1576361charisma
charismas1655311charismas
chrisms1499141ch_risms
czarisms2155751czarisms
chaises124317492cha_ises
chamisas15317812chamisas
chamises153513312chamises
chamisos15307422chamisos
charases131312762charases
chariots1339392chariots
charms135218842char__ms
chartists14126802chartists
chasms135513142cha__sms
chemisms17278212chemisms
chrism13710672ch_rism_
chrisma1456822ch_risma
chrisoms1566092ch_risoms
cladisms1336092cladisms
czarism2056422czarism_
czarists1966222czarists
tsarisms1056652tsarisms
tzarisms1965212tzarisms
agisms9399393__agisms
alarmisms1345003alarmisms
aphorisms1647193aphorisms
archaisms1646073archa_isms
arises65233803__arises
atavisms1346993atavisms
baalisms1238033baalisms
bariums1139143_bariums
binarisms1346413binarisms
boyarisms1645443boyarisms
cabalisms1548433cabalisms
caesarisms1444903caesarisms
cambisms1645803cambisms
camisas113411923c_amisas
camises114218463c_amises
caress85720263c_ares_s
caribes113715643c_aribes
carices114220953c_arices
caries85147623c_ari_es
carinas93622403c_arinas
carious93320283c_arious
caritas93316953c_aritas
caroms105619573c_ar_oms
carroms11512403c_arroms
carses85233653c_ar_ses
centrisms1348053centrisms
cerises94722253c_erises
ceriums1139473c_eriums
chagrins1437073chagri_ns
chaines124518733cha_ines
chains114819703cha_i_ns
chairs114916183cha_i_rs
chais107530313cha_i__s
chaise114916413cha_is_e
chalices15310813chalices
challises14358783challises
chamisa14328853chamis_a
chamise143612853chamis_e
chamiso14348653chamis_o
chamoises16327933chamoises
chams126028503cha___ms
chaoses124715123cha_oses
charades141310853charades
charas114223613char__as
chards125119733char__ds
chares115631803char__es
chargers144011323chargers
charges134615983char_ges
charier124317903chari_er
chariest13315503chariest
charily15310283chari_ly
chariness14310063chariness
charing133721323chari_ng
chariot12316213chari_ot
charismata1752813charismata
charities14312743charities
charity15311023chari_ty
charkas164810963char_kas
charkhas20285023charkhas
charks155219703char__ks
charleys1695633charleys
charlies133414233charlies
charm126124663char__m_
charmers154211333charmers
charnels13328173charnels
charpais1536933charpais
charpoys1834533charpoys
charquis2243933charquis
charros124312143char_ros
charrs115219193char__rs
chars105936643char___s
charters134115583charters
chartist131112133chartis_t
charts115823093char__ts
chases115128233cha__ses
chasings14318253chasings
chasm125518793cha__sm_
chasmy16468543cha__smy
chasses124017503cha_sses
chassis123910663cha_ssis
chastises1437703chastises
chatrooms1685103chatrooms
chausses1345963chausses
chemises153211983chemises
chemism16339303chemism_
chemists152710323chemists
cherish15310463cheris_h
cherishes1767563cherishes
chiasms14357523ch_iasms
chiliasms1693493chiliasms
chimaerisms2052723chimaerisms
chimerisms1953723chimerisms
chirms135113983ch__irms
choriamb1744163choriamb
choriambs1842453choriambs
chorines132917253chorines
chorions13310663chorions
chorizos2245493chorizos
choruses1339983choruses
chrismal1575173ch_rismal
chrismon1544643ch_rismon
chrismons1644003ch_rismons
chrisom1466623ch_risom
christy1536623ch_risty
chutists1335583chutists
chymists18285603chymists
civisms1436073c_ivisms
cladism1238553cladism_
cladists1136723cladists
claims105211573cla_i_ms
claries93422203clari_es
clarions10310493clarions
classisms13295523classisms
clonisms1237793clonisms
colorisms132810793colorisms
cosmisms1446223cosmisms
craniums1297913craniums
crises84529433c__rises
crisis83716343c__risis
crisps104411513c__risps
cubisms13306883c_ubisms
cultisms12126713cultisms
curiums1138503c_uriums
czardoms2243743czardoms
czarinas1935293czarinas
czarist18710223czaris_t
diarists9410363diarists
dualisms1147213dualisms
dwarfisms1841723dwarfisms
echoisms1546143ech_oisms
etatisms1038293etatisms
eucharises1545443eucharises
favisms1535443_favisms
gharials1245123gharials
hakims1537303_haki_ms
harass9313943_haras_s
hareems12428203_hareems
harems115513823_har_ems
harissa1035503_harissa
harissas1145983_harissas
harms106829013_har__ms
harpists1338103_harpists
heroisms1338693_heroisms
holisms123811113_holisms
imagisms1344903imagisms
lyrisms1235653_lyrisms
mechanisms1945723mechanisms
nanisms938833_nanisms
narcisms1267263_narcisms
ogrisms1036443_ogrisms
onanisms1048063onanisms
oralisms10610973oralisms
papisms13238543_papisms
parises94827183_parises
phallisms1645073phallisms
pharisee1347603pharisee
pharisees1444633pharisees
pharoses13310313pharoses
pianisms1249013pianisms
porisms113713453_porisms
prisms104915503__prisms
purisms114110833_purisms
racisms112310813_racisms
realisms102212163realisms
sadisms10359113_sadisms
schisms1437173sch__isms
shariahs14206393shariahs
sharias102516003shari_as
sharifs13279903shari_fs
solarisms1168813solarisms
statisms1039543statisms
thairms1244453tha_irms
tharms115712243thar__ms
theisms1237763th_eisms
thoriums13166403thoriums
tourisms1037613tourisms
tsarism958253tsarism_
tsarists857303tsarists
tzarism1866323tzarism_
tzarists1755693tzarists
uranisms1099973uranisms
verisms123011253_verisms
wholisms1665253wholisms

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.423422437.4
2DLD Change Limit1461622076.62322068.9
3Display Results2072070.0802587.5
 (SQL Overall)1786912077.12625075.9
 
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.