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

186 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
corteges119881(None) 
cortege1098941cortege_
cortexes1797611cortexes
cartages11313312cartages
coatees93816532coate_es
colleges112410512colleges
cordages12310112cordages
corkages1539102corkages
corsages11310362corsages
cortices12615002cortices
corvees124613792corve_es
cottages113310492cottages
portages112613222portages
proteges1149922proteges
vortexes18114042vortexes
bareges105212033bar_eges
bootees94114473boote_es
borages103917163bor_ages
bortzes1838223bort_zes
carnages11312213carnages
carotenes11410203carotenes
cartage10312593cartage_
cartels94618123carte_ls
carters95327243carte_rs
cartes86239473cart__es
centeses1079443centeses
certes84623083cert__es
choregus1484213chor_egus
chortens13308793chorte_ns
chortles133611323chort_les
coatee84327213coate_e_
coaters93525773coate_rs
coccyges1542333coccyges
cockeyes1967033cockeyes
coffees15329573coffe_es
coheres122917693co_heres
coinages11310803coinages
coituses1039623coituses
collages113514233collages
college102410433college_
colleger11227923colleger
collegers12256833collegers
colters93522433colte_rs
comperes143217973comperes
competes144117243competes
comtes106222813comt__es
concedes13311053concedes
congees103517923conge_es
conges94928173co__nges
contemns1237403contemns
contends112810573contends
contents104018213contents
contes84432913cont__es
contests103413383contests
contexts17378653contexts
contuses10413453contuses
convenes132916913convenes
converges1538373converges
convexes20278273convexes
cooees85621893co_oe_es
cooters94525713coote_rs
cooties93725733coot_ies
copters113621273copte_rs
coracles121811163coracles
corbeils12358073corbeils
corbeled1338373corbeled
corbels113813593corbe_ls
corbies113520113cor_bies
cordage11310063cordage_
cordelles1248223cordelles
corders104520873corde_rs
cordites11314603cordites
coreigns1136313coreigns
coreless103013833cor_eless
corers85231073cor_e_rs
cores76361853cor___es
corgis9314403cor__gis
corkage1438373corkage_
corkers134118853corke_rs
cormels113813373corme_ls
corneas94716993corne_as
cornels94716663corne_ls
corneous10310033corneous
cornered11311133cornered
corners94723313corne_rs
cornets94820573corne_ts
cornices12713283cornices
cornuses10310033cornuses
corodies11313693corodies
corotates112714283corotates
corpses113913803cor_pses
corpuses12310063corpuses
corrades111211263corrades
corrects1259573corrects
corries94026783cor_ries
corrodes111310333corrodes
corsage1039803corsage_
corselet10414573corselet
corselets1147313corselets
corses84433463cor__ses
corseted11311473corseted
corsets94819803corse_ts
cortex15311463cort__ex
cortinas102212423cortinas
cortins92421313cort_ins
corvee114320093corve_e_
corves115122523cor__ves
corvets124715023corve_ts
corvettes1447433corvettes
costers94128303coste_rs
costumes1258013costumes
coteries10422703co_teries
cotes76347843co_t__es
cottage104210573cottage_
cottager11306813cottager
cottagers12305373cottagers
cottagey14305233cottagey
cottered112511733cottered
cotters94323433cotte_rs
cotypes1437943co_types
coulees9315503coule_es
courages11311393courages
courteous1145783courteous
courters103015363courte_rs
courtesies1246453courtesies
couters93827283coute_rs
coutures10311973coutures
cowages13310933co_wages
cowhages1736103cowhages
creeses93914623c_reeses
cremes104517993c_r_emes
crepes105419343c_r_epes
cringes103215503c_ringes
crotches153411293crotches
curettes1039313curettes
curtesies1147523curtesies
curtsies1038733curtsies
cuttages11297223cuttages
dotages92311793do_tages
ecotages1136973eco_tages
footages1239053footages
forages114217283for_ages
foregoes1239523for_egoes
forges105024263for__ges
fortes95327183fort__es
forties104323863fort_ies
fortunes1158283fortunes
goatees82710433goate_es
gorges85321893gor__ges
hostages122311693hostages
montages111412183montages
mortgages1344023mortgages
mortices12711553mortices
mortises10713603mortises
oranges84215333_oranges
outages82317323_outages
portage103013643portage_
portaged12228463portaged
portends11358963portends
portents103512823portents
porterages1345963porterages
portered112311533portered
porteress1137923porteress
porters93722703porte_rs
portieres1138203portieres
postages112815323postages
potages102416423po_tages
pottages112910453pottages
protege1059153protege_
protegee1156953protegee
protegees1275393protegees
reges65628783__r_eges
rootages939103rootages
shortages1336513shortages
solfeges1244083solfeges
sorters74221113sorte_rs
sorties74126403sort_ies
sortileges1152743sortileges
tortes64826053tort__es
tortures838913tortures
vertexes18105613vertexes
voltages1237253voltages
vorlages1236033vorlages
vortices1369123vortices
wordages1337053wordages
worthies14310283worthies

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 Filter1786911461620.1701051123.5
2DLD Change Limit1461621866.58022213.1
3Display Results1861860.0603100.0
 (SQL Overall)1786911866.81026239.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.