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

222 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
coagent1031398(None) 
coagents1138451coagents
cogent9321001co_gent
agent65829642__agent
cadent94120362c_adent
coagency1644862coagency
comment1310317702comment
concent114422512concent
congest104618772congest
consent93723112consent
content94326152content
convent123919412convent
coparent12412252coparent
cotangent1246832cotangent
covalent1349222covalent
reagent8716602reagent
agene65621583__agene
agents74816293__agents
ament76036543__ament
anent54931843__anent
argent74023663_argent
cadet85339343c_ade_t
cage75339063c_age__
caged95426363c_age_d
cager85229223c_age_r
cagers95624193c_agers
cages85936013c_age_s
cagey115917823c_age_y
cagiest102916433c_agiest
caging105321023c_aging
candent10417363candent
cant66362033c_a__nt
caret75360563c_are_t
carnet84732873c_arnet
catena8312483c_atena
caveat11417723c_aveat
cement103321673c_ement
cent67451013c___ent
chalet113825993chale_t
chant105932693cha__nt
chaunt11613493cha_unt
cholent12313253cholent
clamant11312433clamant
claret84026573clare_t
clement11313773clement
client8316343c_lient
coact96130583coa__ct
coadmit1247833coadmit
coagula1045413coagula
coagulant1245183coagulant
coaled95022713coale_d
coaler84121713coale_r
coalers94419353coalers
coaliest10316223coaliest
coaling103722823coaling
coalpit1148513coalpit
coaming123818323coaming
coannex1635513coannex
coapt96131533coa__pt
coarsen93210323coarsen_
coarsens10348123coarsens
coarsest1039163coarsest
coast75236273coa__st
coat67558353coa___t
coated94927043coate_d
coatee84327223coate_e
coatees93816553coatees
coater84329573coate_r
coaters93525793coaters
coating103525313coating
coattend1134653coattend
coattest1038863coattest
coaxed165612513coaxe_d
coaxer153912793coaxe_r
coaxers164311083coaxers
coaxes154715633coaxe_s
coaxing173511703coaxing
coden86128543co_den_
codens94821013co_dens
codger105814873codge_r
codgers115113933codgers
coerect11913353coerect
coexert16312363coexert
cogency1547013co_gency
cogently1446323co_gently
cogged116416613cogge_d
cogging123513713cogging
cogon89120903co_gon_
cogons96818113co_gons
coherent13412473coherent
coign85013913coig_n_
coigne94612193coig_ne
coigned11418663coigned
coignes103912153coignes
coigns94410063coig_ns
coinvent1348183coinvent
coldest102514763coldest
collagen11338583collagen_
collagens12256043collagens
collect113314593collect
collet84030363colle_t
comet95946073co_me_t
commend144010183commend
comments142913883comments
compend144010303compend
conceit113218073conceit
concents122516603concents
concept133314443concept
concert113325223concert
confect143614273confect
conge85227593conge__
congeal104011683congeal
congee96024473conge_e
congeed113212313congeed
congees103517923congees
congener112412203congener
conger95024273conge_r
congers104223233congers
conges94928173conge_s
congests113510383congests
congruent1247413congruent
connect113515743connect
consents102715893consents
contend103511893contend
contents104018213contents
contest93523233contest
context163913433context
convect143114483convect
convene123314323convene
convents132614603convents
convert123721473convert
coolant9316463coolant
coolest9318643coolest
coparents1347973coparents
copayment1845893copayment
copen94826433co_pen_
copens106119963co_pens
coquet174318013coque_t
cornet84436733corne_t
coronet94227173coronet
correct11513983correct
corset85636223corse_t
corvet114626933corve_t
coset75748843co_se_t
cosiest93819853cosiest
cosset84125863cosse_t
cotangents1344163cotangents
count74932053co__unt
courant9317973courant
coven106925043co_ven_
covens114919263co_vens
covert114925503co_vert
covet105638943co_ve_t
cowage12310673cowage__
cowages13310943cowage_s
cowiest123614673cowiest
cowmen13810923cowmen_
coyest11316053co_yest
cozen165019703co_zen_
cozens176314923co_zens
coziest184014353coziest
craven114113933craven_
cravens124010123cravens
credent10313973credent
current9313693current
cygnet1237893c_ygnet
docent92918683do_cent
dragnet91211433dragnet
exigent1539513exigent
foment113718303fo_ment
forget106326393forge_t
fornent10312933fornent
forwent13310533forwent
fragment1448373fragment
fulgent1138903fulgent
gent56954393___gent
gorget87123863gorge_t
hogget114715763hogge_t
horrent10313553horrent
lagend838743_lagend
lament85024943_lament
latent64124303_latent
lodgment1245983lodgment
loment84021473lo_ment
longest84114953longest
magenta1038623_magenta
magnet9320663_magnet
margent10316693margent
misagent11410723misagent
moment103319683mo_ment
mordent10313993mordent
morgen9312203morgen_
morgens10310463morgens
nocent83217413no_cent
oaken95814383_oaken_
oaten55222403_oaten_
oogeny10117923_oogeny
orgeat7515033_orgeat
orient6322533_orient
pageant10312783_pageant
parent83230423_parent
patent84524923_patent
plangent1138803plangent
ponent82821593po_nent
portent93619643portent
potent84223353po_tent
pungent10311233pungent
reagents959623reagents
regent74127673_regent
ringent8315153ringent
rodent7519243ro_dent
sagest74920263_sagest
solvent10310833solvent
sorbent92915243sorbent
subagent1147913subagent
talent6323323_talent
tangent8315003tangent
torment9316173torment
torrent7313413torrent
turgent8712393turgent
urgent73816043_urgent
zoogeny2044363zoogeny

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.420425454.8
2DLD Change Limit1340272226.61020276.4
3Display Results2222220.0802775.0
 (SQL Overall)1786912227.11025132.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.