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

163 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
charities1431274(None) 
clarities11312481clarities
canities101519262c_anities
cavities131412612c_avities
chanties132615802cha_nties
charlies133414232char_lies
chastities1545862chastities
christies1449262ch_risties
clarifies1448632clarifies
parities10522972_parities
rarities8316332_rarities
alacrities1246673alacrities
amities9317383__amities
analities9715873analities
barites94322333_barit_es
calamities1448473calamities
calvities1438943calvities
capacities1647693capacities
carates95630613c_arat_es
carditis11310223c_arditi_s
carditises1346963c_arditises
caribes113715643c_ari_bes
carices114220953c_ari_ces
caries85147623c_ar__ies
carioles10817073c_arioles
caritas93316953c_arit_as
caritases1139753c_aritases
carnies94123963c_ar_nies
carnifies1439893c_arnifies
carnitines1277813c_arnitines
carotids11229943c_arotids
carotins102315583c_arotins
carries94328013c_ar_ries
cartes86239473c_ar_t_es
catties94023053c_a_tties
cavitied14126813c_avitied
cecities12312043c_ecities
celerities1289773celerities
cerites94823433c_erit_es
chaines124518733cha_i_nes
chaises124317493cha_i_ses
chalices15310813chali_ces
challies133915643cha_llies
chamises153513313chami_ses
chammies172910163cha_mmies
chantries14310293chantries
chapatis15127943chapati_s
chapiter1536603chapit_er
chapiters1635203chapiters
chappies172610093cha_ppies
characids1745263characids
characins1647593characins
charades141310853char_ades
charases131312763char_ases
chares115631803char___es
charges134615983char__ges
charier124317903char__ier
chariest13315503char__iest
chariness14310063chariness
charioted1595863charioted
charioteer1552753charioteer
charioteers1652433charioteers
charioting1645723charioting
chariots1339393chari_ots
charismas1655313charismas
charisms15710263chari_sms
charity15311023charit__y
charladies1644023charladies
charlie123011923char_lie_
charlottes1543823charlottes
charpais1536933charpai_s
charquis2243933charqui_s
charrier1378683char_rier
charriest1438253char_riest
charted135116853char_t_ed
charter123918303char_t_er
charters134115583char_ters
charting142614193char_ting
chartist131112133char_tist
chartists14126803chartists
chartless1435703char_tless
charts115823093char_t__s
chastise1348173cha_stise
chastises1437703chastises
chattier1337513cha_ttier
chattiest1448203cha_ttiest
chayotes1636503chayot_es
chedites1438263chedit_es
cherishes1767563cherishes
cherries131812983cher_ries
chertier1387873cher_tier
chertiest1438793cher_tiest
chilies124218303ch__ilies
chiralities1646513chiralities
chitins122713793ch__itins
chitties13310773ch_itties
chivies153412853ch__ivies
chlorites142311963chlorit_es
chorines132917253chori_nes
chorioids1545683chorioids
chortles133611323chor_tles
christie1347783ch_ristie_
cities84524853c___ities
claries93422203clar__ies
clarified1546973clarified
clarifier1446123clarifier
clarifiers1544013clarifiers
clerisies1147253clerisies
coalifies1439113coalifies
comities12317793c_omities
cowrites133011593cowrit_es
critics112811093c__ritics
crudities1247743crudities
cuprites1259023cuprit_es
curites93919863c_urit_es
cyanites132610163cyanit_es
czaritzas1991643czaritzas
dualities10310443dualities
edacities1247773edacities
ferities111416713_ferities
gharries12318203ghar_ries
gravities1338303gravities
habitues13306413_habitues
halites103221193_halit_es
hardies114923233_har_dies
harpies123818313_har_pies
harries103525493_har_ries
hearties11315413hear_ties
hilarities1347153hilarities
imparities14108643imparities
inanities9312443inanities
laities7320343_la_ities
laxities1539093_laxities
molarities12129433molarities
opacities1347943opacities
oralities91214123oralities
ovalities12119803ovalities
ovaritides1443973ovaritides
ovaritis1145953ovariti_s
parties93230863_par_ties
pharisees1444633pharisees
polarities121211773polarities
purities10316283_purities
qualities18311223qualities
rarifies11311933_rarifies
realities9316313realities
sanities81219773_sanities
scarcities1446403scarcities
scarifies1439603scarifies
shanties113116583sha_nties
sharpies13411223shar_pies
shorties11414583shor_ties
smarties10312873smar_ties
sparsities1247323sparsities
suavities1248413suavities
thirties1139723thir_ties
thorites11312393thorit_es
unclarities1345333unclarities
vanities111414493_vanities
varieties1259203_varieties
varsities1239243_varsities
verities111418043_verities
whities133113253wh__ities

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 Filter1786911486410.420425454.8
2DLD Change Limit1486411636.86021667.8
3Display Results1631630.0632587.3
 (SQL Overall)1786911637.34324334.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.