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

248 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
chemics1634958(None) 
chemic153012091chemic_
chymics19295531chymics
chebecs1635012chebecs
chemical1748392chemical
chemicals1845602chemicals
chemise143211502chemise
chemises153211982chemises
chemism16339302chemism
chemisms17278212chemisms
chemist143615002chemist
chemists152710322chemists
chemos13311722chem_os
chevies153511442chevies
chics123920942ch__ics
chymic18317882chymic_
clerics1149332clerics
comics124015562c_omics
cretics112911652cretics
hemic125718622_hemic_
hemins113417572_hemins
academics1643533academics
alchemic1745253alchemic_
alchemies1654833alchemies
alembics1442963alembics
anemias92512143anemias
anemic102713693anemic_
atomics113110853atomics
bohemias1545983bohemias
cadmic1338983cadmic_
cammies134016483cammies
cebids11439173c_ebids
cedis84317083c_edi_s
ceils75019403c_e_ils
celiacs11157893c_eliacs
ceramics1446803ceramics
cercis104614493c_ercis
cerias83321983c_erias
ceric94023093c_eric_
chains114819703ch_ains
chairs114916183ch_airs
chais107530313ch_ai_s
chalice14311043chalice
chalices15310813chalices
chamisa14328853chamisa
chamisas15317813chamisas
chamise143612853chamise
chamises153513313chamises
chamiso14348653chamiso
chamisos15307423chamisos
chammies172910163chammies
chamois143512193chamois
champacs1934633champacs
champs154915683cham_ps
chams126028503cham__s
chasmic16177983chasmic_
cheapies1539033cheapies
cheapos14418513cheapos
cheaps134613683che_aps
cheats114519543che_ats
chebec1536963chebec_
check164714713che__ck
checks174912703che_cks
cheders134512393cheders
chedite1338863chedite
chedites1438263chedites
cheeks154712783che_eks
cheeps135312913che_eps
cheerios13317593cheerios
cheeros123711643cheeros
cheers114518913che_ers
cheeses123613103cheeses
chefing16359033chefing
chefs136214663che__fs
chegoes1337333chegoes
chelas113817203che_las
cheloids1438033cheloids
chemo12313633chem__o
cheques2136863cheques
cherish15310463cherish
cherries131812993cherries
cherts115617233che_rts
cherubs1434553cherubs
chervils1644553chervils
chess105016923che__ss
chesses124112633chesses
chests114916263che_sts
chetahs15347073chetahs
cheths14389823che_ths
chevied16357483chevied
cheviot1546933cheviot
cheviots1643783cheviots
chevres15379793chevres
chewers154111143chewers
chewier1537593chewier
chewiest16177293chewiest
chewing163911143chewing
chewink19315113chewink
chewinks20313183chewinks
chews135418513che__ws
chias104625523ch__ias
chic115925203ch__ic_
chica125818263ch__ica
chicas135916473ch__icas
chick165419133ch__ick
chicks175317593ch__icks
chico124218253ch__ico
chicos134614833ch__icos
chilies124218303chilies
chilis115517873chili_s
chimars144010593chimars
chimbs153910303chim_bs
chimers144515143chimers
chimes134922573chim_es
chiming153311833chiming
chimlas1437453chimlas
chimps155713663chim_ps
chins105631463ch__ins
chips125721253ch__ips
chis95933313ch__i_s
chitins122713793chitins
chits105424573ch__its
chivies153412853chivies
choice132010523ch_oice
choices142010613ch_oices
choirs114911883ch_oirs
chomps155112223chom_ps
chopins142312243chopins
choric133515903choric_
chromic1639863chromic_
chronics1538683chronics
chumps154313823chum_ps
chums125015833chum__s
chymes165912153chym_es
chymist17268173chymist
chymists18285603chymists
chymous1775703chymous
cimices13279803c_imices
civics13397823c_ivics
cleric10612133cleric_
clerids1049093clerids
clevis1158963clevi_s
clinics11338743clinics
clitics11279973clitics
coedits10310243coedits
coempts1335683coempts
coheirs1236753cohe_irs
colics104219903c_olics
comic114721813c_omic_
commies133718453commies
commits133812383commits
conics103920593c_onics
cosmic12410343cosmic_
cosmids1237633cosmids
credits1039973credits
cremains1238693cremains
cremes104517993crem_es
cremini11229063cremini
creminis12208253creminis
cretic102816283cretic_
cretins93216423cretins
crevice1436153crevice
crevices1536713crevices
critics112811093critics
cubics123810163c_ubics
cumins103314933c_umins
cummins1358963cummins
cyesis1148573cyesi_s
cynics13377363c_ynics
demic105119193_demic_
demies94825803_demies
demits94918073_demits
elemis8312383elemi_s
emetics11610723emetics
emic86422753__emic_
emirs76116163__emirs
emits75421473__emits
endemics1346273endemics
enemies9313693enemies
epics95014283__epics
haemic133210083haemic_
haemins122811403haemins
heils85222193_he_ils
heirs85618563_he_irs
helices12313723_helices
helios94816633_helios
hematics151712193_hematics
hemes105031083_hem_es
hemin103620933_hemi_n
hemps126917333_hem_ps
hems95534943_hem__s
herdics13249523_herdics
hermits12312143_hermits
heroics122912003_heroics
homies114524733_homies
humic124113243_humic_
icterics1247063icterics
irenics937833irenics
ischemias1644183ischemias
ischemic1744673ischemic_
luetics937323luetics
medics114115353_medics
mics87435153___mics
mimics1289363_mimics
ohmic1237833oh_mic_
osmics1036463_osmics
phobics16286703phobics
phonemics1844933phonemics
phonics143110723phonics
photics142810483photics
physics17265963physics
poetics11312073poetics
polemics1448183polemics
premies113823063premies
premiss113513813premiss
pyemias1436803pyemias
pyemic1537893pyemic_
reemits9611303reemits
relics84517903_relics
remiss84216353_remiss
remits85622943_remits
rhemes115913183rhem_es
rheumic1443543rheumic_
sachemic1746083sachemic_
scenics1137773scenics
schemas1468163schem_as
schematics1945673schematics
schemers1576713schemers
schemes1489663schem_es
scheming1636633scheming
semis74623533_semi_s
sferics1236133sferics
sheiks132510013she_iks
sherifs13299683sherifs
spherics1537073spherics
theins95015423the_ins
theirs94610353the_irs
thematics16188113thematics
themes115319253them_es
theming133610473theming
theriacs1336543theriacs
thermic1439333thermic_
thermits1338513thermits
thesis94913733thesi_s
thetic11412893thetic_
thymic16307423thymic_
uremias9249503uremias
uremic103410513uremic_

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.406440125.6
2DLD Change Limit1340272486.65320145.3
3Display Results2482480.0803100.0
 (SQL Overall)1786912487.13925030.3
 
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.