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

271 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
coempt1231103(None) 
coempts1335681coempts
compt116328221co_mpt
clept95725772cle_pt
coapt96131532co_apt
coedit9316242coedit
coempted1535342coempted
comet95946072co_met
commit124016702commit
comp106731252co_mp_
compo115318572co_mpo
comps115526052co_mps
compts125216652co_mpts
contempt1447472contempt
coopt95929852co_opt
crept95125892cre_pt
exempt1737452exempt
kempt134318462_kempt
tempt95124842_tempt
accept123210643acce_pt
adept81219643ade_pt
attempt1145373attempt
benempt1346263benempt
camp106336453c_amp_
campi116217783c_ampi
campo115219763c_ampo
camps116330263c_amps
campy145116183c_ampy
celt65646713c_e_lt
cement103321673c_ement
cent67451013c_e_nt
cep75736333c_e_p_
cepe84926653c_e_pe
ceps86125953c_e_ps
cermet10321153cermet
champ145017963champ_
champs154915683champs
champy18509613champy
chapt125827643c_hapt
cheap126915943cheap_
cheapo134810083cheapo
cheaps134613683cheaps
cheat105732453che_at
cheep125416503cheep_
cheeps135312913cheeps
chemic153012093chemic
chemist143615003chemist
chemo12313633chem_o
chemos13311723chemos
chert105232103che_rt
chest104926143che_st
chimp145216473chimp_
chimps155713663chimps
chomp144815663chomp_
chomps155112223chomps
chump145315443chump_
chumps154313823chumps
clamp115517653clamp_
clamps124515083clamps
clapt98027173c_lapt
claspt104513413claspt
cleat76335063cle_at
cleft106222853cle_ft
clement11313773clement
clepe94617383cle_pe
clipt96324273c_lipt
clomp115615703clomp_
clomps125212233clomps
clump115517453clump_
clumps1215314643clumps
clumpy15409573clumpy
coact96130583co_act
coadmit1247833coadmit
coalpit1148513coalpit
coapts104614013co_apts
coast75236273co_ast
coat67558353co__at
cobalt10317393cobalt
cobnut10311323cobnut
cockpit1747993cockpit
cocomat13413623cocomat
coed77140543coe__d
coedits10310243coedits
coeds85920163coe_ds
coelom10310433coelom
coemploy1743323coemploy
coempting1636073coempting
coenact11311803coenact
coerce10310403coerce
coerect11913353coerect
coesite9713623coesite
coeval1138893coeval
coexert16312363coexert
coexist1638583coexist
coft97939683co__ft
cogent9321003cogent
cohort1110720263cohort
cohost115217213cohost
collet84030363collet
colt67158243co__lt
coma87134853co_m_a
comae97128423co_mae
comal95125133co_mal
comas95833003co_mas
comate104124843co_mate
comb106632113co_m_b
combat12316753combat
combe116223543co_mbe
combo114519433co_mbo
combs116122963co_mbs
come87547703co_m_e
comedo11359603comedo
comedy14378233comedy
comely134213733comely
comer95832693co_mer
comers105328083comers
comes97246993co_mes
cometh134811683cometh
comets105823583comets
comfit133112423comfit
comfy153710213co_mfy
comic114721813co_mic
comity13312713co_mity
comix163513203co_mix
comma114514793co_mma
commas124814573commas
commata1338483commata
comment1310317703comment
commie124215523commie
commits133812383commits
commix19407763commix
commixt20357623commixt
common12310803common
commute134310443commute
commy144712643co_mmy
compact153712213co_mpact
compart134016003co_mpart
compas125817063co_mpas
comped135919873co_mped
compel124412893co_mpel
compete134716553co_mpete
complot13310683co_mplot
comply152810383co_mply
comport133616843co_mport
compos124818803co_mpos
compost134515353co_mpost
compote135616463co_mpote
compted143813533co_mpted
compute134513663co_mpute
comte96125473co_mte
concept133314443concept
confit113316403confit
contempo1444833contempo
contempts1545063contempts
coomb115615703coom_b
coombe124110093coombe
coombs124210193coombs
coop87238653co_op_
coops96229643co_ops
coopts105814583co_opts
coot67860383co__ot
cop711162373co__p_
cope86847383co__pe
copemate1439993copemate
coplot10518273coplot
copout10418783copout
cops86751373co__ps
copy116229803co__py
coquet174318013coquet
coremia11310363coremia
corm85735383corm__
cormel103815603cormel
corms95626223corm_s
cornet84436733cornet
corps95927043co_rps
corrupt1149103corrupt
corset85636223corset
corvet114626933corvet
coset75748843co_set
cosmic12410343cosmic
cosmid11810643cosmid
cosmist11311333cosmist
cosmos10311753cosmos
cosset84125863cosset
cost68057943co__st
cot510483223co___t
cotype1346823cotype
count74932053co_unt
coup86729793co_up_
coupe96023483co_upe
coups95522473co_ups
court75532773co_urt
covert114925503covert
covet105638943co_vet
cowman13910373cowman
cowmen13810923cowmen
cowpat13312033cowpat
coyest11316053coyest
coypu12349873co_ypu
cramp115120693cramp_
crampit1338863crampit
cramps125615563cramps
crampy154710993crampy
credit9315193credit
creep95218103creep_
creeps104213623creeps
creepy13418803creepy
cremate113816183cremate
creme94319323crem_e
cremes104517993cremes
crepe95520723cre_pe
crepy124812703cre_py
crest74632693cre_st
crimp115615803crimp_
crimps124613453crimps
crimpy15489393crimpy
crump115616423crump_
crumpet133711063crumpet
crumps124514343crumps
crypt123715233c_rypt
demit84832303_demit
doest65829523doe_st
emit65438423__emit
empty1247763__empty
exempts1844023exempts
foeman11311233foeman
foemen11310523foemen
foment113718303foment
format113021363format
gemot84024233_gemot
hemp115725623_hemp_
hemps126917333_hemps
hempy154912763_hempy
inept73622153ine_pt
kemp126418773_kemp_
kemps135012523_kemps
kept106232953_ke_pt
leapt75027473_leapt
lept66440883_le_pt
loment84021473loment
moment103319683moment
motmot10311073motmot
nonempty1543503nonempty
ocelot8813383ocelot
omit65337373_o_mit
oomph1236973_oomph
opt57545543_o__pt
poem86225773poem__
poems95715553poem_s
poet65552903poe__t
pomp106225463po_mp_
pomps115316193po_mps
preempt1337723preempt
prompt12313013prompt
reemit8717223reemit
remet74843723_remet
remit75737223_remit
romp85926573ro_mp_
romps94617543ro_mps
sept65844363_se_pt
slept75728103sle_pt
swept105720603swe_pt
temp85323333_temp_
tempi94912203_tempi
tempo95214973_tempo
temps95417133_temps
tempts10439453_tempts
unkempt1544763unkempt
vomit102622573vo_mit
wept95635053_we_pt
yclept1336013ycle_pt

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 Filter1786911127160.393454684.5
2DLD Change Limit1127162716.23318083.7
3Display Results2712710.0763565.8
 (SQL Overall)1786912716.70226662.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.