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

212 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
coempts133568(None) 
coempt12311031coempt_
compts125216651co_mpts
coapts104614012co_apts
coedits10310242coedits
coempted1535332coempted
comets105823582co_mets
commits133812382commits
compas125817062co_mpas
compos124818802co_mpos
comps115526052co_mp_s
compt116328222co_mpt_
contempts1545062contempts
coopts105814582co_opts
exempts1844022exempts
tempts10439452_tempts
accepts13356353acce_pts
adepts9117103ade_pts
attempts1243103attempts
campos125217953c_ampos
camps116330263c_amp_s
campus125213923c_ampus
celts75325783c_e_lts
cements112714223c_ements
cents74730333c_e_nts
cepes94424463c_e_pes
ceps86125953c_e_p_s
cermets1139713cermets
champs154915683champ_s
cheapos14418513cheapos
cheaps134613683cheap_s
cheats114519543che_ats
cheeps135312913cheep_s
chemics16349583chemics
chemist143615003chemist
chemists152710323chemists
chemos13311723chem_os
cherts115617233che_rts
chests114916263che_sts
chimps155713663chimp_s
chomps155112223chomp_s
chumps154313823chump_s
clamps124515083clamp_s
cleats84919313cle_ats
clefts114610163cle_fts
clematis1248653clematis
clepes104214623cle_pes
clept95725773cle_pt_
clomps125212233clomp_s
clumps1215314643clump_s
coacts105314333co_acts
coadmits1345713coadmits
coalpits1245403coalpits
coapt96131533co_apt_
coasts85719143co_asts
coats75635003co__ats
cobalts1139203cobalts
cobnuts1135353cobnuts
cockpits1845743cockpits
cocomats1449403cocomats
coedit9316243coedit_
coeds85920163coe__ds
coeloms1139063coeloms
coemploy1743323coemploy
coemploys1842763coemploys
coempting1636073coempting
coenacts1246403coenacts
coerces11311943coerces
coerects1258543coerects
coesite9713623coesite
coesites101313093coesites
coevals1237873coevals
coexerts1734883coexerts
coexist1638583coexist
coexists1735653coexists
cohorts123411103cohorts
cohosts12398813cohosts
collets93517903collets
colts76633293co__lts
comas95833003co_m_as
comate104124843co_mate
comates114123643co_mates
combats13311683combats
combes125321733co_mbes
combos125316613co_mbos
combs116122963co_m_bs
comedos12329073comedos
comers105328083co_mers
comes97246993co_m_es
comet95946073co_met_
cometh134811683co_meth
comfits14328743comfits
comics124015563co_mics
comity13312713co_mity
commas124814573co_mmas
commata1338483commata
comments142913883comments
commies133718453commies
commit124016703commit_
commons13311043commons
commute134310443commute
commutes143011893commutes
comous10816503co_mous
comp106731253co_mp__
compacts16368903co_mpacts
comparts144210833co_mparts
compass13379563co_mpass
comped135919873co_mped
compel124412893co_mpel
compels133210883co_mpels
compete134716553co_mpete
competes144117243co_mpetes
complots1438163co_mplots
comply152810383co_mply
compo115318573co_mp_o
comports143411983co_mports
compose135716663co_mpose
compost134515353co_mpost
composts144210913co_mposts
compote135616463co_mpote
compotes144716513co_mpotes
compted143813523co_mpted
compute134513663co_mpute
computes143914553co_mputes
comte96125473co_m_te
comtes106222813co_mtes
concepts143110303concepts
confits122811423confits
contempt1447473contempt_
coombes133810663coombes
coombs124210193coom_bs
coops96229643co_op_s
coopt95929853co_opt_
coots75636843co__ots
copemate1439993copemate
copemates1549483copemates
copes97747103co__pes
coplots11511593coplots
copouts11311083copouts
cops86751373co__p_s
coquets18399893coquets
cormels113813373cormels
cormous11312353cormous
corms95626223corm__s
cornets94820573cornets
corps95927043co_rp_s
corpus106015293co_rpus
corrupts1244983corrupts
corsets94819803corsets
corvets124715023corvets
cosets85824403co_sets
cosmids1237633cosmids
cosmist11311333cosmist
cosmists1237993cosmists
cosmos10311753cosm_os
cossets95014283cossets
costs77231143co__sts
cots68054843co___ts
cotypes1437943cotypes
counts84618273co_unts
coupes105022523co_upes
coups95522473co_up_s
courts84216173co_urts
coverts124813813coverts
covets114819643co_vets
cowpats1437713cowpats
coypus13389303co_ypus
crampits1436273crampits
cramps125615563cramp_s
credits1039973credits
creeps104213623creep_s
cremate113816183cremate
cremates124216003cremates
cremes104517993crem_es
crepes105419343cre_pes
crept95125893cre_pt_
crests85218703cre_sts
crimps124613453crimp_s
crumpets14335943crumpets
crumps124514343crump_s
crypts13397743c_rypts
demits94918073_demits
emits75421473__emits
empty1247763__empty
exempt1737453exempt_
foments122912053foments
formats123113573formats
gemots93712153_gemots
hemps126917333_hemp_s
kemps135012523_kemp_s
kempt134318463_kempt_
loments93413473loments
moments113113123moments
motmots1166133motmots
nonempty1543503nonempty
ocelots977233ocelots
omits75018263_o_mits
oomphs1344723_oomphs
opts68124743_o__pts
poems95715553poem__s
poets76024443poe__ts
pomps115316193po_mp_s
preempts1444543preempts
prompts1337473prompts
reemits9611303reemits
remits85622943_remits
romps94617543ro_mp_s
septs75420603_se_pts
tempos103812293_tempos
temps95417133_temp_s
tempt95124843_tempt_
vomits112610923vo_mits

Search took 7 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 Limit1340272126.22021547.7
3Display Results2122120.0762789.5
 (SQL Overall)1786912126.70226662.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.