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

129 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
chards12511973(None) 
cards85137931c_ards
chads116122231cha_ds
charas114223611charas
chard116124741chard_
chares115631801chares
charks155219701charks
charms135218841charms
charrs115219191charrs
chars105936641char_s
charts115823091charts
chords125214631chords
echards1337961echards
hards96435651_hards
shards104319171shards
awards107113452awards
bards87139642_bards
beards94116672beards
boards94616932boards
cads76144532c_a_ds
caids85226432c_aids
cairds96411512cairds
canards10311202canards
carbs96031462c_arbs
card710245872c_ard_
cares77369182c_ares
carks115534212c_arks
carls77037422c_arls
carns75937562c_arns
carps96932252c_arps
carrs75730852c_arrs
cars67364762c_ar_s
carts78946292c_arts
chad105525502cha_d_
chadri1238142chadri
chafes145017912chafes
chaffs17459612chaffs
chains114819702chains
chairs114916182chairs
chais107530312cha_is
chakras16428502chakras
chalks155412142chalks
champs154915682champs
chams126028502cha_ms
changs125215372changs
chants115020392chants
chaos105622862cha_os
chapes135421872chapes
chaps125326062cha_ps
char95132152char__
charade13129912charade
charades141310852charades
chare105231982char_e
chared125423692chared
charge125114212charge
charges134615982charges
charism14712202charism
chark144222712char_k
charka154011702charka
charkas164810962charkas
charm126124662char_m
charr104821782char_r
charro114212962charro
charros124312152charros
charry145012112charry
chart105038282char_t
chary135023132char_y
chases115128232chases
chasms135513142chasms
chats105730092cha_ts
chaws135022462cha_ws
chays135319742cha_ys
cherts115617232cherts
chirks155414842chirks
chirms135113982chirms
chiros114617772chiros
chirps135414002chirps
chirrs114514982chirrs
chirus114615692chirus
chord115917262chord_
chores114828022chores
chorus115014772chorus
churls115411072churls
churns114910232churns
churrs115111512churrs
clads85722732cla_ds
claros84015112claros
cords86030622c_ords
cowards1339612cowards
curds85725612c_urds
czardas1934672czardas
czars164812912czar_s
echard1249222echard_
fards96629842_fards
guards84611572guards
hands95327382_hands
hard85443502_hard_
hardy125622062_hardy
hares86255542_hares
harks126333432_harks
harls85634502_harls
harms106829012_harms
harps105926872_harps
harts88441592_harts
herds96424682_herds
hoards104912622hoards
hurds95219072_hurds
lards65331862_lards
liards75212612liards
nards65928462_nards
orchards1445912orchards
pards85634332_pards
pharos11312062pharos
pochards1646852pochards
sards64736182_sards
shads95124482sha_ds
shairds11216262shairds
shard96125962shard_
shares95236412shares
sharks135019722sharks
sharns95516982sharns
sharps115516082sharps
sherds105614722sherds
swards105415132swards
tharms115712242tharms
thirds10438602thirds
wards97734402_wards
wharfs1546372wharfs
yards95324612_yards

Search took 4 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 Limit825511292.61031628.7
3Display Results1291290.0304300.0
 (SQL Overall)1786911293.00059563.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.