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

149 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
chartist13111213(None) 
chartists14126801chartists
artist64125542__artist
chariest13315502chariest
chariot12316212char_iot
charism14712202char_ism
charriest1438252charriest
charting142614192charting
charts115823092chart_s_
chastest1349702chastest
chastise1348172chastise
chattiest1448202chattiest
chertiest1438792chertiest
chutist1239452ch_utist
czarist18710222czar_ist
harpist12312352_harpist
alarmist1049123alarmist
artiest73121993__artiest
artiste73813693__artiste
artists74215593__artists
autist64324943__autist
baptist11311873_baptist
bhaktis1633433bhaktis_
cambist13312113c_ambist
carlish12312763c_arlish
cartes86239473c_artes_
carting104228283c_arting
carts78946293c_art_s_
casuist9411303c_asuist
cattiest103016333c_attiest
cattish12410723c_attish
centrist10314863centrist
ceramist12310933ceramist
chablis14368563chablis_
chaffiest2045413chaffiest
chairlift1742653chairlift
chais107530313cha__is_
chaise114916413cha__ise
chalkiest1837083chalkiest
challis124613463challis_
chamisa14328853cha_misa
chamise143612853cha_mise
chamiso14348653cha_miso
chamois143512193chamois_
chanciest1638373chanciest
chanties132615803chanties
chanting143413533chanting
chants115020393chant_s_
chaotic14310043chaoti_c
chapatis15127943chapatis_
charas114223613char_as_
chards125119733char_ds_
chares115631803char_es_
charges134615983charges_
charging152910773charging
charier124317903char_ier
charily15310283char_ily
charing133721323char_ing
chariots1339393char_iots
charisma1576363char_isma
charisms15710263char_isms
charities14312743charities
charity15311023char_ity
charkas164810963charkas_
charking183512613charking
charks155219703char_ks_
charlie123011923charli_e
charlies133414233charlies
charming163012033charming
charms135218843char_ms_
charpais1536933charpais_
charquis2243933charquis_
charrier1378683charrier
charring142913163charring
charros124312143charros_
charrs115219193char_rs_
chars105936643char__s_
chart105038283char___t
charted135116853chart_ed
charter123918303chart_er
charters134115583charters
chartless1435703chartless
chassis123910663chassis_
chastised1554683chastised
chastiser1444373chastiser
chastises1437703chastises
chastity1645273chastity
chats105730093cha_t_s_
chattier1337513chattier
chattily1634603chattily
chatting142810143chatting
chemist143615003ch_emist
cherish15310463cher_ish
chertier1387873chertier
cherts115617233chert_s_
chestiest1438313chestiest
chiantis1346593chiantis_
chirkest1735383chirkest
chirpiest16286473chirpiest
chrism13710673ch_r_ism
christy1536623ch_r_isty
churlish1644903churlish
chutists1335583ch_utists
chymist17268173ch_ymist
cladist10311973cla_dist
classist104010383classist
coarsest1039163coarsest
coassist10298803coassist
coatis85122603coa_tis_
coattest1038863coattest
craftiest1436913craftiest
cultist91412713c_ultist
curtest9713963c_urtest
czarism2056423czar_ism
czarists1966223czar_ists
diarist8517113diar_ist
etatist7415033eta_tist
flautist1186803flautist
gharris11306433gharris_
hardest113118413_hardest
hardiest123416333_hardiest
harpists1338103_harpists
harts88441593_hart_s_
harvest132112753_harvest
hastiest112916493_hastiest
heartiest12311103heartiest
hornist102314823_hornist
narcist9512443_narcist
nonartist949423nonartist
orchardist1653343orchardist
peartest10311303peartest
phallist1338983phallist
phantast1346923phantast
phattest1336913phattest
shantis103313103shantis_
sharpest1339143sharpest
shirtiest1239323shirtiest
shortest11310783shortest
shortish1437423shortish
shortlist1246683shortlist
smartest10310183smartest
statist7317723sta_tist
tartest72517533_tartest
tartiest82718313_tartiest
tartish101512633_tartish
tsarist7712253tsar_ist
tzarist1659103tzar_ist
wartiest113614643_wartiest
whatsit1345823wha_tsit

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.1561145455.1
2DLD Change Limit1461621497.26320124.2
3Display Results1491490.0632365.1
 (SQL Overall)1786911497.48223882.8
 
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.