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

297 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
chacmas163799(None) 
chacma1537901chacma_
cacas95627982c_ac_as
camas96333522c_a_mas
chachkas22173732chachkas
chakras16428482chakras
challas124414122challas
champs154915682cha_mps
chams126028502cha_m_s
chapman1637892chapman
charas114223592cha_ras
charkas164810952charkas
charms135218832charm_s
chasmal14158212chasmal
chasms135513142chasm_s
chiasmas15306582chiasmas
chicas135916462chic_as
chromas142512682chromas
dharmas1356502dharmas
halmas117017892_halmas
shamas113717932sha_mas
shammas14358712shammas
abacas104414723abac_as
acacias11510393acacias
acmes96020653__acmes
agamas97413443aga_mas
agmas85919873__agmas
almas76629773__almas
amas67746293__a_mas
atmas75721013__atmas
bhaktas1633643bhaktas
brahmas1436733brahmas
cabman123812503c_abman
caca85528083c_ac_a_
cacao95420003c_ac_ao
cacaos104616183c_acaos
caches137926913c_aches
cactus104912233c_actus
caeomas1138393caeomas
caiman103615663c_aiman
caimans113811783c_aimans
callas84526753c_allas
calms95222353c_alm_s
camass104114183c_a_mass
cames97047313c_a_mes
camos95927613c_a_mos
camps116330263c_a_mps
cams87047283c_a_m_s
canchas143212403canchas
cannas84518403c_annas
canvas113813333c_anvas
capias10318353c_apias
carman103920743c_arman
casas75327843c_a_sas
cayman133613213c_ayman
caymans14349513c_aymans
chablis14368553chablis
chabuks1843733chabuks
chachka21173643chachka
chadar1239343cha_dar
chadars1338273chadars
chadors1338723chadors
chads116122233cha__ds
chaeta11310683chaeta_
chaetae1238603chaetae
chaetal1238283chaetal
chafers154512723chafers
chafes145017913cha_fes
chaffs17459613cha_ffs
chaines124518733chaines
chainman1585173chainman
chains114819703cha_ins
chairman15106373chairman
chairmans1685133chairmans
chairs114916173cha_irs
chais107530313cha__is
chaises124317493chaises
chakra15437533chakra_
chalah143511653cha_lah
chalahs15289883chalahs
chalazas2245893chalazas
chalcids1635883chalcids
chalehs15268803chalehs
chalets122813473chalets
chalks155412143cha_lks
challa114014193challa_
challah15458323challah
challahs16377563challahs
challis124613463challis
chalupas1554383chalupas
cham115532313cha_m__
chamade15138433cha_made
chamades16138633cha_mades
chamisa14328853cha_misa
chamisas15317793chamisas
chamise143612853cha_mise
chamiso14348653cha_miso
chammies172910153chammies
chammy18488953cha_mmy
chamois143512173chamois
champ145017963cha_m_p
champac1834953champac
champacs1934623champacs
champak2034493champak
champaks2134093champaks
champy18509613cha_mpy
chancels15439083chancels
chancers154313483chancers
chances145218093chances
chancres15429363chancres
changes134517583changes
changs125215373cha_ngs
chants115020393cha_nts
chaos105622863cha__os
chaoses124715113chaoses
chapeau1435523chapeau
chapeaus1544973chapeaus
chapels14429153chapels
chapes135421873cha_pes
chapmen1637283chapmen
chaps125326063cha__ps
charcoal15165733charcoal
charcoals16174673charcoals
chards125119723cha_rds
chares115631803cha_res
charges134615983charges
charismas1655293charismas
charka154011703charka_
charkhas20285023charkhas
charks155219703cha_rks
charm126124663charm__
charmed154714243charmed
charmer144913663charmer
charmers154211323charmers
charpai1436623charpai
charpais1536923charpais
charros124312143charros
charrs115219183cha_rrs
chars105936633cha__rs
charts115823093cha_rts
chasers123714893chasers
chases115128233cha_ses
chasm125518793chasm__
chasmed154710173chasmed
chasmic16177983chasmic
chasmy16468543chasm_y
chasses124017503chasses
chassis123910663chassis
chatchkas23172783chatchkas
chateau1236263chateau
chateaus1345983chateaus
chats105730093cha__ts
chaunts1267083chaunts
chawers154412033chawers
chaws135022463cha__ws
chays135319743cha__ys
chazan20269133cha_zan
chazans21268123chazans
chazzan20204853chazzan
chazzans21234503chazzans
checks174912703chec_ks
chelas113817203ch_elas
chemos13311723ch_emos
chias104625513ch__ias
chiasma14366983chiasma_
chiasmal15285023chiasmal
chiasms14357523chiasm_s
chiasmus15343903chiasmus
chica125818263chic_a_
chichis1737073chichis
chicks175317593chic_ks
chicles143512503chicles
chicos134614833chic_os
chics123920943chic__s
chimar133911463ch_imar
chimars144010573ch_imars
chimbs153910303ch_imbs
chimes134922573ch_imes
chimlas1437453chimlas
chimps155713663ch_imps
chinas115119383ch_inas
chirms135113983chirm_s
chlamys1733783chlamys
chloasmas1642483chloasmas
chocks174815313choc_ks
cholas114817993ch_olas
chollas123811353chollas
chomps155112223ch_omps
choreas124414203choreas
chroma132912473chroma_
chromes142914933chromes
chromos142610273chromos
chucks174812933chuc_ks
chufas14397673ch_ufas
chukkas1532783chukkas
chumps154313823ch_umps
chums125015833ch_um_s
chuppas1644123chuppas
chymes165912153ch_ymes
cicadas1235983cicadas
cicalas1139293cicalas
cinemas1138023cinemas
clachan1437183clachan
clachans1546413clachans
clachs133511323clac_hs
clacks144516343clac_ks
claims105211573claim_s
clamps124515083cla_mps
clams95127673cla_m_s
cloacas1136233cloac_as
coaches144018693coaches
coachman1744983coachman
coacts105314323coac_ts
coalas87418963coa_las
cocas95926573c_oc_as
cocoas104915743c_ocoas
comas95833003c__omas
commas124814573c_ommas
conchas144013313conchas
cracks144817003crac_ks
cramps125615563cra_mps
crams96229153cra_m_s
curacoas1246033curacoas
curcumas1454853curcumas
cycas126513823c_yc_as
cymas126417883c__ymas
czardas1934673czardas
dachas124113253_dachas
dharma1276103dharma_
dharnas1155373dharnas
drachmas1644863drachmas
dramas95814653dra_mas
exactas16336433exactas
facias113415803_facias
fracas11311993frac_as
gamas85431353_ga_mas
gammas115714693_gammas
gramas94317203gra_mas
grammas12499773grammas
haceks15447863_haceks
hackman1836433_hackman
hacks144928713_hac_ks
haemal113811643_haemal
haems105517013_haem_s
hahas117118443_ha_has
halma108219253_halma_
halms105225213_halm_s
halvas124714173_halvas
hamal104623103_ha_mal
hamals114816813_ha_mals
hames106138703_ha_mes
hammal134512063_hammal
hammals14409213_hammals
hammam12419333_hammam
hammams13386433_hammams
hams96446133_ha_m_s
hamzas20119013_hamzas
hansas94616043_hansas
harms106829013_harm_s
hazmat20312263_hazmat
hazmats2136603_hazmats
jicamas1845043jicamas
karmas123013733_karmas
kwachas1943063kwachas
lamas75532793_la_mas
llamas888973lla_mas
magmas115512503_magmas
mahatmas1543863mahatmas
mamas95930773_ma_mas
mammas94616403_mammas
miasmas1167743miasmas
nachas114914193_nachas
pacas96029403_pac_as
pachas135017143_pachas
plasmas113010753plasmas
rhachis1555693rhachis
schemas1468163sch_emas
shackos16429023shackos
shacks154817563shac_ks
shaman113314273sha_man
shamans123610893sha_mans
shames114726223sha_mes
shammash18293743shammash
shammes144312833shammes
shammos14307203shammos
shamos114216983sha_mos
shams105829413sha_m_s
shamus114112813sha_mus
sharias102516003sharias
shawms14579563shawm_s
thacks154311923thac_ks
tharms115712243tharm_s
traumas938583traumas
ulamas8910453ula_mas
whackos19375263whackos
whacks184610483whac_ks
whams135515643wha_m_s

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.1561145455.1
2DLD Change Limit1340272977.45317983.0
3Display Results2972970.0963093.8
 (SQL Overall)1786912977.70523191.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.