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

215 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
congests11351038(None) 
congest104618771congest_
contests103413381contests
coagents1138452coagents
conceits122813612conceits
concents122516602concents
concepts143110302concepts
concerts123016062concerts
confects153110872confects
confess12399902confes_s
congeals11309852congeals
congees103517922conge_es
congers104223232conge_rs
conges94928172conge__s
congested1338672congested
congrats11311432congrats
congress1138072congres_s
connects123010562connects
conquests2045362conquests
consents102715892consents
consists10310592consists
contents104018212contents
contest93523232contest_
contexts17378652contexts
convects153410992convects
convents132614602convents
converts133213552converts
decongests1443242decongests
ingests83210982_ingests
longest84114952longest_
nonguests1044392nonguests
songfests1342982songfests
angsts738863_ang_sts
bonesets1036843bon_esets
bongoists1244843bongoists
boniest93318993boniest_
bonnets94812803bonne_ts
canoeists1147163canoeists
centeses1079443centeses
centesis1058143centesis
chests114916263c__hests
cineasts1045543cineasts
coagent10313983coagent_
coasts85719143co__asts
coattests1143463coattests
codgers115113933codge_rs
coerects1258543coerects
coexerts1734883coexerts
coexists1735653coexists
cogent9321003co_gent_
cognises11610043cognises
cohosts12398813co_hosts
coinfects16344573coinfects
coinvents1445663coinvents
coldest102514763coldest_
collects12279783collects
collets93517903colle_ts
combusts1445503combusts
comets105823583co_me_ts
comments142913883comments
composts144210913composts
conceals123111013conceals
concedes13311053concedes
conceit113218073conceit_
concent114422513concent_
concept133314443concept_
concepti14328273concepti
conceptus15295873conceptus
concerns122710833concerns
concert113325223concert_
concerti122912603concerti
concerto123311613concerto
concertos132711133concertos
concocts1138633concocts
concuss1138063concus_s
condemns1336293condemns
condenses12710133condenses
conducts13118713conducts
conduits111210063conduits
cones76457423con_e__s
coneys115218423con_e_ys
confect143614273confect_
confers124120093confe_rs
confesses1438623confesses
confetti1345993confetti
confetto1346253confetto
confits122811423con_fits
confuses13310363confuses
congas94417033cong__as
conge85227593conge___
congeal104011683conge_al
congee96024463conge__e
congeed113212313conge_ed
congener112412203congener
congeners122511133congeners
conger95024273conge__r
congeries12316403congeries
congesting14410113congesting
congestion1349043congestion
congestions1449313congestions
congestive1647613congestive
congius103210073cong_ius
congoes103617303cong_oes
congos94219883cong__os
congous103615083cong_ous
congresses1348023congresses
conies84338593conie__s
conioses10313313conioses
coniosis1048133coniosis
conkers133721043conke_rs
connect113515743connect_
conners94023113conne_rs
conquest1939553conquest_
consensus1144923consensus
consent93723113consent_
consist9316033consist_
consorts101512343consorts
consults10219983consults
contacts123215213contacts
contemns1237403contemns
contempts1545063contempts
contends112810573contends
content94326153content_
contes84432913conte__s
contessa1044583contessa
contessas1145023contessas
contested12310693contested
contester11311183contester
contesters12410183contesters
context163913433context_
contorts101112643contorts
contrasts112211043contrasts
contuses10413453contuses
convect143114483convect_
convenes132916913convenes
convent123919413convent_
converses14311163converses
conversos1446893conversos
convert123721473convert_
convexes20278273convexes
conveys15308223conve_ys
convicts15337713convicts
coolest9318643coolest_
copyists1545993copyists
coquets18399893coque_ts
cornets94820573corne_ts
corniest102117303corniest_
corrects1259573corrects
corsets94819803corse_ts
corvets124715023corve_ts
cosets85824403co_se_ts
cosiest93819853cosiest_
cosmists1237993cosmists
cossets95014283cosse_ts
costs77231143co___sts
cotangents1344163cotangents
countess103710053countes_s
coverts124813813co_verts
covets114819643co_ve_ts
cowiest123614673cowiest_
coxless1637743coxles_s
coyest11316053co_yest_
coyness1277323coynes_s
coziest184014353coziest_
crests85218703c__rests
cygnets1333813cygne_ts
decongest1345633decongest_
digests93610613_digests
egests74411253__egests
fondest11312403fondest_
forests104114953fo_rests
forgets113813793forge_ts
funfests14253563funfests
gests66028813___gests
gorgets94711783gorge_ts
hangnests1344543hangnests
hoggets12498323hogge_ts
honest94822423hon_est_
honesty13378053hon_esty
incests92711383_incests
infests10279793_infests
ingest73119003_ingest_
ingesta8357863_ingesta
invests10319683_invests
joneses1438963jon_eses
loggets9378913logge_ts
longers84819543longe_rs
longes75925573longe__s
longness938553longnes_s
molests93311563mo_lests
mongers104217273monge_rs
mongst93512603mong_st_
monists93614783mon_ists
mostests1036833mostests
nests55728003__n_ests
nonets64118703non_e_ts
nonguest938563nonguest_
nonpasts1046553nonpasts
obtests9136233_obtests
onsets64013543_onse_ts
orgeats838353_orgeats
pongees104212543ponge_es
renests74014213ren_ests
songfest1236843songfest_
songless9218823songles_s
sonless72612613sonles_s
sonnets74211993sonne_ts
suggests1044713suggests
tangents938713tangents
tongers84116013tonge_rs
toniest73218903toniest_
tonlets73212503tonle_ts
unrests7229463_unrests
wrongest1236733wrongest_
youngest1244903youngest_

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461622157.53019410.6
3Display Results2152150.0962239.6
 (SQL Overall)1786912157.78222962.1
 
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.