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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

156 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
charts11582309(None) 
carts78946291c_arts
chants115020391chants
charas114223611charas
chards125119731chards
chares115631801chares
charks155219701charks
charms135218841charms
charrs115219191charrs
chars105936641char_s
chart105038281chart_
chats105730091cha_ts
cherts115617231cherts
harts88441591_harts
arts49650262__arts
boarts84716872boarts
cants77036942c_ants
carats85929022c_arats
carbs96031462c_arbs
cards85137932c_ards
cares77369182c_ares
carets85330772c_arets
carks115534212c_arks
carls77037422c_arls
carns75937562c_arns
carps96932252c_arps
carrs75730852c_arrs
cars67364762c_ar_s
cart66570342c_art_
carte75940422c_arte
cartes86239472c_artes
casts77237792c_asts
cats66356342c_a_ts
chads116122232cha_ds
chaeta11310682chaeta
chafes145017912chafes
chaffs17459612chaffs
chains114819702chains
chairs114916182chairs
chais107530312cha_is
chakras16428502chakras
chalets122813472chalets
chalks155412142chalks
champs154915682champs
chams126028502cha_ms
changs125215372changs
chant105932692chant_
chanty145215822chanty
chaos105622862cha_os
chapes135421872chapes
chaps125326062cha_ps
chapt125827642chapt_
char95132152char__
chard116124742char_d
chare105231982char_e
chared125423692chared
charge125114212charge
charges134615982charges
chariots1339392chariots
charism14712202charism
charity15311022charity
chark144222712char_k
charka154011702charka
charkas164810962charkas
charm126124662char_m
charr104821782char_r
charro114212952charro
charros124312142charros
charry145012112charry
charted135116852charted
charter123918302charter
charters134115582charters
chartist131112132chartist
chary135023132char_y
chases115128232chases
chasms135513142chasms
chaste114617392chaste
chat95546132cha_t_
chatty14419362chatty
chaunts1267082chaunts
chaws135022462cha_ws
chays135319742cha_ys
cheats114519542cheats
chert105232102chert_
cherty144612472cherty
chests114916262chests
chints115117832chints
chirks155414842chirks
chirms135113982chirms
chiros114617772chiros
chirps135414002chirps
chirrs114514982chirrs
chirus114615692chirus
chits105424572ch_its
chords125214632chords
chores114828022chores
chorus115014772chorus
chotts113610992chotts
churls115411072churls
churns114910232churns
churrs115111512churrs
clarets94111102clarets
claros84015112claros
clasts84817292clasts
coacts105314332coacts
coapts104614012coapts
coasts85719142coasts
coats75635002coa_ts
cohorts123411102cohorts
courts84216172courts
crafts115312742crafts
czars164812912czar_s
darts67635732_darts
echards1337962echards
farts88336842_farts
ghats95818612gha_ts
ghauts10447782ghauts
haets86525122_haets
hafts116219462_hafts
halts85230102_halts
hants86335402_hants
hards96435652_hards
hares86255542_hares
harks126333432_harks
harls85634502_harls
harms106829012_harms
harps105926872_harps
hart76865772_hart_
hats76858252_ha_ts
hearts96218942hearts
hurts86922822_hurts
karts97630112_karts
khats125316012kha_ts
marts77442232_marts
parts77743372_parts
pharos11312062pharos
quarts154715932quarts
recharts1337662recharts
scarts85321492scarts
shafts125411442shafts
shards104319172shards
shares95236412shares
sharks135019722sharks
sharns95516982sharns
sharps115516082sharps
shirts94918342shirts
shorts95321742shorts
smarts86218002smarts
starts65423122starts
tarts57242022_tarts
tharms115712242tharms
thwarts1345022thwarts
warts814840402_warts
wharfs1546372wharfs
whats117718992wha_ts
whorts125111432whorts

Search took 3 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 Filter178691825510.360496363.9
2DLD Change Limit825511562.47033421.5
3Display Results1561560.0463391.3
 (SQL Overall)1786911562.87662131.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.