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

200 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
chamade1513845(None) 
chamades16138651chamades
charade13129911charade
chamise143612852chamise
champed174111482champed
charades141310852charades
comade114415322c_omade
hamada1239922_hamada
hamate113319832_hamate
alamode1038153alamode
amaze166016603__amaze
amide86128483__amide
cade76443913c___ade
camail10314833c_amail
camas96333523c_ama_s
camases114216343c_amases
camass104114183c_amass
came87648753c_am__e
camisade1374823c_amisade
camise103319633c_amise
cammie124615293c_ammie
camped134720233c_amped
canape10913513c_anape
carafe115416163c_arafe
carate84734003c_arate
cascade12118603cascade
ceramide1347973ceramide
chacma1537903chacma__
chacmas1638003chacma_s
chad105525503ch__ad_
chadar1239353chada_r
chadars1338293chadars
chads116122233ch__ads
chaetae1238603chaetae
chafe135117353ch__afe
chafed154813913chafed_
chaffed19387703chaffed
chaine115119223cha_ine
chained133812693chained
chaired134211243chaired
chaise114916413cha_ise
chalah143511663chala_h
chalahs15289883chalahs
chalaza2145733chalaza
chalazae2244423chalazae
chalice14311043chalice
chalked17449863chalked
challie124012853challie
chalone12312103chalone
cham115532313cham___
chamber164011063chamber
chamfer17399863chamfer
chamisa14328853chamisa
chamises153513313chamises
chamiso14348653chamiso
chammied18215973chammied
chammies172910163chammies
chammy18488953cham_my
chamois143512193chamois
chamoix21275643chamoix
champ145017963cham__p
champac1834953champac
champaca1943203champaca
champacs1934633champacs
champagne1942783champagne
champak2034493champak
champaks2134103champaks
champer163813413champer
champs154915683cham_ps
champy18509613cham_py
chams126028503cham__s
chance134617093cha_nce
chanced154113213chanced
chancre14348783chancre
change124116753cha_nge
changed144214143changed
chantage1446633chantage
chanted134015953chanted
chapati14118023chapati
chape125221143ch__ape
chapman1637893chapma_n
chapped172711443chapped
chappie16298653chappie
charas114223613chara_s
charases131312763charases
chard116124743cha_rd_
chards125119733cha_rds
chare105231983ch__are
chared125423693chared_
charge125114213cha_rge
charged144614023charged
charked174814013charked
charlady1743403charlady
charlie123011923charlie
charmed154714253charmed_
charred134614483charred
charted135116853charted
chase105127123ch__ase
chased125019293chased_
chasmal14158213chasma_l
chasmed154710173chasmed_
chasse115114603cha_sse
chassed134712133chassed
chaste114617393cha_ste
chatted133411893chatted
chawed155214603chawed_
chayote1536493chayote
chazan20269133chaza_n
chazans21268123chazans
chelae113614603chela_e
chelate122914893chelate
chemise143211503chemise
chicane1489553chicane
chide115321013ch__ide
childe124711213ch_ilde
chimar133911473chima_r
chimars144010593chimars
chime125322593chim__e
chimed145814833chimed_
chimere144010633chimere
chlamydes2062293chlamydes
choanae1236863choana_e
cholate122114933cholate
chomped17329773chomped
chorale124313353chorale
chromate15312783chromate
chromide1648053chromide
chummed17396443chummed
chumped17379493chumped
chyme156512503chym__e
clade85821013c__lade
cladode1134613cladode
clamant11312433clamant
clambake1843893clambake
clammed14369963clammed
clamped144012043clamped
clavate1238713clavate
climate11312833climate
cockade1638133cockade
comae97128423c_oma_e
comake144413423c_omake
comate104124843c_omate
commode1438123commode
comrade12139213comrade
corrade101111043corrade
couvade1335063couvade
crambe1239073cram_be
crammed143710123crammed
cramped144712183cramped
cremate113816183cremate
crusade1036053crusade
cyanate12259703cyanate
cyanide13298843cyanide
cymae126713013c_yma_e
damage10410773_damage
diamide1138473diamide
dramady1443553dramady
facade1238803_facade
gambade1336383_gambade
hade85440193_h__ade
halide103417993_halide
hamadas1339673_hamadas
hamal104623113_hama_l
hamals114816823_hamals
hamates122917683_hamates
hamaul114210873_hamaul
hame97043133_ham__e
hammada1545093_hammada
hammed144116973_hammed
handmade1545963_handmade
hexade17438903_hexade
homage121210603_homage
humane112812173_humane
humate113214443_humate
imamate1138103imamate
khanate1437073khanate
made75440243___made
manmade1237963manmade
mismade12129353mismade
ohmage1295063oh_mage
parade94720643_parade
pomade113611333_pomade
premade12311443premade
ramada9310183_ramada
ramate83921683_ramate
remade94316983_remade
scalade10359263scalade
shade95125583sh__ade
shamable15168803shamable
shaman113314283shama_n
shamans123610903shamans
shamas113717943shama_s
shamble14149263shamble
shame105726703sham__e
shamed125120213shamed_
shammed153911423shammed
tamale83717403_tamale
thanage11117943thanage
unmade92911063_unmade
whammed18345133whammed

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 Filter1786911340270.403443402.0
2DLD Change Limit1340272007.06318975.9
3Display Results2002000.0802500.0
 (SQL Overall)1786912007.54623680.2
 
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.