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

187 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
congress113807(None) 
compress1439052compress
confess12399902con_fess
congees103517922cong_ees
congers104223232cong_ers
conges94928172cong_e_s
congest104618772cong_est
congests113510382cong_ests
congoes103617302congoe_s
congrats11311432congrats
congressed1445462congressed
congresses1348022congresses
ingress838652_ingress
longness938552longness
mongrels1135332mongrels
ogress7529502_o_gress
songless9218822songless
aggress935593_aggress
ancress978613_ancress
bondless1148813bondless
boneless10310213boneless
bongoes104314113bongoe_s
boniness102211803boniness
cangues10611823cangue_s
canoness1039393canoness
caress85720263c__aress
cateress102311613cateress
centres93817123centre_s
coalless1038193coalless
coatdress1243193coatdress
coatless1039693coatless
codeless112010113codeless
codgers115113933codg_ers
coenures1048683coenure_s
coffrets1645363coffrets
cognises11610043cognises
coheiress1443353coheiress
coherers132310733coherers
coheres122917693cohere_s
coignes103912153coigne_s
coldness1137953coldness
coloreds1138093coloreds
colorers10312183colorers
colorless1145683colorless
colures9315143colure_s
comfreys1843333comfreys
concerns122710833concerns
concerts123016063concerts
conches144019813conche_s
concrete12411083concrete
concretes13411473concretes
concuss1138063con_cuss
condoes104319203condoe_s
condores113315643condore_s
cones76457423con__e_s
coneys115218423con__eys
conferees14610623conferees
confers124120093con_fers
confrere1347563confrere
confreres1448033confreres
confuses13310363confuses
congaed11399743congae_d
congas94417033cong__as
conge85227593cong_e__
congeal104011683cong_eal
congeals11309853congeals
congee96024473cong_e_e
congeed113212313cong_eed
congeners122511133congeners
conger95024273cong_e_r
congeries12316403congeries
congius103210073cong_ius
congos94219883cong__os
congous103615083cong_ous
congressing1545603congressing
congressman1651883congressman
congressmen1652803congressmen
congruent1247413congruent
congruous1244343congruous
conies84338593con_ie_s
conifers133611703conifers
conines93827793conine_s
conioses10313313conioses
conjurers18126233conjurers
conjures17119913conjure_s
conkers133721043con_kers
conners94023113con_ners
conquers1938223conquers
conquest1939553conquest
conquests2045363conquests
contes84432913con_te_s
contessa1044583con_tessa
contest93523233con_test
contests103413383con_tests
contras93015623contr_as
contrast102614783contrast
contrasts112211043contrasts
controls10311393controls
contuses10413453contuses
converse13310263converse
converses14311163converses
converso1336423converso
conversos1446893conversos
converts133213553converts
conveys15308223con_veys
cookless14258633cookless
coolness1037743coolness
cordgrass1343013cordgrass
cordless11299963cordless
coreless103013833coreless
corers85231073co__rers
cores76361853co__re_s
corniness112611183corniness
corses84433463co__rses
cosiness103214283cosiness
costless10310003costless
costrels1038933costrels
coughers14399963coughers
countess103710053countess
countless1146373countless
courses94218893co_urses
coverers132712123coverers
coverless1436803coverless
coxless1637743co_xless
coyness1277323co_yness
coziness19319823coziness
cress75022833c___ress
cutgrass1144343cutgrass
cypress1434653c_ypress
digress938323_digress
doggrels1142633doggrels
doneness9411513doneness
dongles93212873dongle_s
egress73310433__egress
engross837123_engross
fangless1237663fangless
fogless1138193fo_gless
fondness1237213fondness
fortress1136753fortress
gangrels1094973gangrels
goneness9310763goneness
hongies112716473hongie_s
honorees1148773honorees
honorers1139263honorers
hotpress1344303hotpress
huntress1144833huntress
jointress1643053jointress
kingless13288693kingless
langrels9106173langrels
loneness8512093loneness
longers84819543long_ers
longes75925573long_e_s
longest84114953long_est
longies82916553longie_s
mongeese1144593mongeese
mongers104217273mong_ers
mongoes103415713mongoe_s
mongrel1036333mongre_l
nongreasy1342773nongreasy
nongreen945513nongreen
nonguest938563nonguest
nonguests1044393nonguests
ogres65818633_o_gre_s
oneness7512143_oneness
oppress1135993_oppress
pingrass1146003pingrass
pongees104212543pong_ees
portress1038323portress
progress1137023progress
regress82711453_regress
rungless956733rungless
songfest1236843songfest
songfests1342983songfests
songstress1152413songstress
sonless72612613son_less
sundress936983sundress
tigress836093_tigress
toneless8610393toneless
tongers84116013tong_ers
tongues879693tongue_s
undress838893_undress
votaress1144223votaress
votress1035483vo_tress
wingless122910023wingless
wrongness1344513wrongness
youngness1343373youngness
zoneless1737823zoneless

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.420425454.8
2DLD Change Limit1461621876.53322372.9
3Display Results1871870.0762460.5
 (SQL Overall)1786911877.02925422.0
 
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.