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

262 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
chammies17291016(None) 
cammies134016481c_ammies
chammied18215971chammied
shammies15259681shammies
whammies18265511whammies
cammie124615292c_ammie_
challies133915642challies
chamades16138652chamades
chamise143612852cha_mise
chamises153513312chamises
chamois143512192chamoi_s
chamoises16327932chamoises
chamomiles1953502chamomiles
chanties132615802chanties
chappies172610092chappies
charlies133414232charlies
chummier1734512chummier
chummiest1834642chummiest
clammier1435842clammier
clammiest1535732clammiest
commies133718452c_ommies
crummies1437642crummies
hammier143510652_hammier
hammiest152610002_hammiest
jammies183611292_jammies
mammies104314762_mammies
shammes144312832shamm_es
shammied16265542shammied
shimmies15287802shimmies
tammies113814682_tammies
amies76837693__a_mies
ammines11312673__ammines
armies85123693__armies
cabbies133115163c_abbies
caddies113718383c_addies
camails11311753c_amails
camases114216343c_amases
cames97047313c_a_m_es
camise103319633c_a_mise
camises114218463c_amises
camomiles15155633c_amomiles
campier133313273c_ampier
campiest142212133c_ampiest
candies104125613c_andies
caries85147623c_a_ries
carmines123617863c_armines
carnies94123963c_arnies
carries94328013c_arries
catties94023053c_atties
cavies114525003c_a_vies
chablis14368563chabli_s
chacmas1638003chacm_as
chafes145017913cha__fes
chaffier1935473chaffier
chaffiest2045413chaffiest
chagrins1437073chagrins
chaines124518733cha_ines
chains114819703cha__ins
chairs114916183cha__irs
chais107530313cha__i_s
chaise114916413cha__ise
chaises124317493cha_ises
chalcids1635893chalcids
chalices15310813chalices
chalkier1736753chalkier
chalkiest1837083chalkiest
challie124012853challie_
challis124613463challi_s
challises14358783challises
chalones13312173chalones
chamade15138453chamade_
chamber164011063cha_mber
chambers173410623chambers
chamfer17399863cha_mfer
chamfers18409223chamfers
chamisa14328853cha_misa
chamisas15317813chamisas
chamiso14348653cha_miso
chamisos15307423chamisos
chammy18488953chamm__y
chammying2243353chammying
chamoised17335323chamoised
chamoix21275643chamoi_x
chamomile1853603chamomile
champacs1934633champacs
champaks2134103champaks
champed174111483cha_mped
champer163813413cha_mper
champers173311623champers
champing183610933champing
champion17276353champion
champions18875783champions
champs154915683cha_m_ps
chams126028503cha_m__s
chances145218093cha_nces
chancier1538823chancier
chanciest1638373chanciest
chancres15429363chancres
changes134517583cha_nges
chantries14310293chantries
chaoses124715123cha_oses
chapes135421873cha__pes
chapmen1637283chapm_en
chappie16298653chappie_
charades141310853charades
charases131312763charases
chares115631803cha__res
charges134615983cha_rges
charier124317903cha_rier
chariest13315503cha_riest
charities14312743charities
charlie123011923charlie_
charmed154714253charm_ed
charmer144913663charm_er
charmers154211333charmers
charming163012033charming
charmless1633583charmless
charms135218843charm__s
charrier1378683charrier
charriest1438253charriest
chases115128233cha__ses
chasmed154710173chasm_ed
chasmic16177983chasmi_c
chasms135513143chasm__s
chasses124017503cha_sses
chassis123910663chassi_s
chastise1348173chastise
chastises1437703chastises
chattier1337513chattier
chattiest1448203chattiest
chausses1345963chausses
chayotes1636503chayotes
cheapies1539033cheapies
chemics16349583ch_emics
chemise143211503ch_emise
chemises153211983chemises
cherries131812983cherries
chevies153511443ch_evies
chilies124218303ch_ilies
chillies134113483chillies
chimblies1845033chimblies
chimeres153511313chimeres
chimes134922573ch_im_es
chippies17309753chippies
chitties13310773chitties
chivies153412853ch_ivies
chivvies1954423chivvies
chlamydes2062293chlamydes
chlamyses1962493chlamyses
chromes142914933chrom_es
chromides1747603chromides
chromier1538033chromier
chromiest1637783chromiest
chromites16310963chromites
chromizes2547603chromizes
chuckies1937703chuckies
chummed17396443chumm_ed
chummily2042843chummily
chumminess1943113chumminess
chumming18366203chumming
chymes165912153ch_ym_es
chymics19295533ch_ymics
clammed14369963clamm_ed
clammer134211793clamm_er
clammers143510693clammers
clammily1743633clammily
clamminess1643613clamminess
clamming15329373clamming
claries93422203cla_ries
coadmires1444033coadmires
coadmits1345713coadmits
commie124215523c_ommie_
commits133812383c_ommits
commixes2177353c_ommixes
crambes1339963cra_mbes
cramboes1436543cramboes
crammed143710123cramm_ed
crammer134010963cramm_er
crammers14369353crammers
cramming15339433cramming
crampier14288903crampier
crampiest15268613crampiest
crampits1436273crampits
crannies10313013crannies
crappies142911153crappies
crazies183413853cra_zies
crummie1336153crummie_
crummier1435603crummier
crummiest1545563crummiest
cummins1358963c_ummins
dummies123012133_dummies
gammier123711193_gammier
gammiest13339333_gammiest
gharries12318203gharries
ghazies2036913gha_zies
gimmies123010113_gimmies
grammes123611323gramm_es
gremmies1355993gremmies
hackies163418243_hackies
haemins122811403_haemins
hamates122917683_hamates
hames106138703_ha_m_es
hammals14409223_hammals
hammams13386443_hammams
hammed144116973_hamm_ed
hammer138120033_hamm_er
hammers144216063_hammers
hammily1736063_hammily
hamminess1635713_hamminess
hamming153014093_hamming
hankies143617763_hankies
hardies114923233_hardies
harmines132715143_harmines
harmins123716723_harmins
harpies123818313_harpies
harries103525493_harries
hawkies173311243_hawkies
homies114524723_h_omies
immies102412443__immies
jammier18408023_jammier
jammiest19307203_jammiest
jemmies18318333_jemmies
jimmies18328783_jimmies
khamsins1743393khamsins
lambies113015113_lambies
mamies104626243_ma_mies
mammees104411143_mammees
mammie94313783_mammie_
mommies103912273_mommies
mummies103812843_mummies
phasmids16195183phasmids
pommies133712843_pommies
psammites1542843psammites
ramies84630463_ra_mies
rammier112811023_rammier
rammiest12299933_rammiest
rummies113212793_rummies
scampies1439323scampies
shambles15159043shambles
shames114726223sha_m_es
shammas14358723shamm_as
shammed153911423shamm_ed
shammer144613143shamm_er
shammers153710843shammers
shamming16289413shamming
shammos14307203shamm_os
shamois123210423shamoi_s
shamuses1336153shamuses
shandies122714103shandies
shannies113411253shannies
shanties113116583shanties
sharpies13411223sharpies
shavies134213203sha_vies
shimmied16294983shimmied
swamies123712063swa_mies
tammie104212693_tammie_
tommies113812983_tommies
tummies113012033_tummies
whammed18345133whamm_ed
whamming19275223whamming
whimsies1635193whimsies
yummies14359533_yummies

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.423422437.4
2DLD Change Limit1461622626.51622431.2
3Display Results2622620.0932817.2
 (SQL Overall)1786912627.03225411.1
 
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.