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 “charismas” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

62 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
charismas165531(None) 
charisma1576361charisma_
charisms15710261charism_s
chamisas15317812chamis_as
charism14712202charism__
charismata1752812charismata
chrisma1456822ch_risma_
chrismal1575172ch_rismal
chrisms1499142ch_rism_s
czarisms2155752czarism_s
harissas1145982_harissas
aristas7413523__aristas
baristas1039723_baristas
camisas113411923c_amis_as
camisias12268603c_amisias
carinas93622413c_ari_nas
cariocas1239663c_ariocas
caritas93316963c_ari_tas
chacmas1638003cha__cmas
chainman1585193cha_inman
chairman15106383cha_irman
chairmans1685143cha_irmans
chaises124317493cha_is_es
chamisa14328853chamis_a_
chamises153513313chamis_es
chamisos15307423chamis_os
charas114223613char___as
charases131312763charas_es
chariness14310063chariness
chariots1339393chari_ots
charismatic2053543charismatic
charismatics2152423charismatics
charities14312743charities
charkas164810963char__kas
charkhas20285023char_khas
charms135218843char__m_s
chartists14126803chartis_ts
charwoman1944673charwoman
chasmal14158213cha__smal
chasms135513143cha__sm_s
chemisms17278213chemism_s
cherishes1767563cherishes
chiasmas15306593ch_iasmas
chloasmas1642493chloasmas
choriambs1842453choriambs
chrism13710673ch_rism__
chrismon1544643ch_rismon
chrismons1644003ch_rismons
chrisoms1566093ch_risoms
chromas142512693ch_r_omas
cladisms1336093cladism_s
czarinas1935303czari_nas
czarism2056423czarism__
czarists1966223czaris_ts
czaritzas1991643czaritzas
dharmas1356513dhar__mas
harianas1139163_harianas
harissa1035503_harissa_
pharisees1444633pharisees
sharias102516003shari__as
tsarisms1056653tsarism_s
tzarisms1965213tzarism_s

Search took 9 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 Filter1786911486410.440406115.9
2DLD Change Limit148641627.57619620.0
3Display Results62620.0302066.7
 (SQL Overall)178691628.04622208.7
 
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.