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

255 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
cognises1161004(None) 
cognise1059681cognise_
cognised1256311cognised
cognizes2058031cognizes
agonises92613162agonises
cognates11311582cognates
cognize1957682cognize_
cognized2136292cognized
cognizer2055862cognizer
cognizers2164432cognizers
colonises112814012colonises
conies84338592co_ni_es
conines93827792co_nines
conioses10313312co_nioses
connives1339722connives
cornices12713292cornices
cornuses10310032cornuses
hognoses12108132hognoses
ionises72916432io_nises
recognises1345532recognises
aconites10314353aco_nites
adonises92611433adonises
aegises8311373aeg_ises
agnizes17328843_agnizes
agonies83016623agoni_es
agonise83112693agonise_
agonised10248483agonised
agonistes10266263agonistes
agonists9289833agonists
agonizes182610583agonizes
anises64826693__anises
bogies94724313bog_i_es
bogyisms1643823bogyisms
bonuses94212953bo_nuses
boonies93422483booni_es
bornites10310983bornites
botanises1139163botanises
caddises12329353caddises
caginess11310303caginess
camises114218463c_amises
canines93724033c_anines
canonises11410803canonises
carnies94123963carni_es
cassises103811743cassises
censes83721803c_en_ses
cercises12410933cercises
cerises94722253c_erises
chaises124317493c_haises
chamises153513313chamises
chemises153211983chemises
chintses1337113chintses
clevises1336903clevises
clonisms1237793clonisms
clonuses1057133clonuses
cocaines121314443cocaines
codeines113114523codeines
codfishes1845643codfishes
codices12512583co_dices
codrives1437663codrives
coenures1048683coenures
coesites101313093coesites
coexists1735653coexists
cogencies1448103cogencies
cogitos1037613cog_itos
cognacs1256043cogn_acs
cognate10312203cognate_
cognising1347043cognising
cognomen1346083cognomen
cognomens1443863cognomens
coignes103912153coign__es
coinages11310803coinages
coincides1446433coincides
coituses1039623coituses
coleuses1039723coleuses
colies84837053co_li_es
colitises11311743colitises
collides113214473collides
collies94326583colli_es
collinses1138283collinses
colonies103620013coloni_es
colonise102514283colonise_
colonised12248723colonised
colonists112512503colonists
colonizes202613183colonizes
combines142814623combines
commies133718453commi_es
commixes2177353commixes
communises1646563communises
compiles14311983compiles
composes145017113composes
comprises15510943comprises
conches144019813co_nches
concise11314473concise_
conciser12310243conciser
concisest1348253concisest
condoes104319203co_ndoes
conenoses1188903conenoses
cones76457423co_n__es
confess12399903co_nfess
confides14310573confides
confines13315653confines
confuses13310363confuses
congees103517923co_ngees
conges94928173co_n_ges
congests113510383congests
congius103210073congi_us
congoes103617303co_ngoes
congress1138073congress
conics103920593co_ni_cs
conifer123212643co_nifer
conifers133611703co_nifers
coniines10415363coniines
conine84528553co_nine_
conins84327233co_ni_ns
coniosis1048133co_niosis
coniums11311863co_niums
connive1238993connive_
connived1436433connived
conniver1337493conniver
connivers1436933connivers
connotes10311453connotes
consists10310593consists
contes84432913co_n_tes
contuses10413453contuses
cookies133719273cooki_es
coolies93824963cooli_es
coonties10513803coonties
cooties93725733cooti_es
copies104130303co_pi_es
coppices1638243coppices
copses104922473co__pses
copyists1545993copyists
corbies113520123corbi_es
cordites11314623cordites
cornice11612933cornice_
corniced1368593corniced
corniches1666673corniches
cornicles1368243cornicles
cornier93017093corni_er
corniest102117303corniest
cornifies1439003cornifies
corniness112611183corniness
corpses113913803co_rpses
corpuses12310063corpuses
corries94026793corri_es
corses84433463co__rses
cortices12615013cortices
coses76949493co___ses
cosies84932153co_si_es
cosines94122673co_sines
cosiness103214283cosiness
cosmisms1446223cosmisms
cosmists1237993cosmists
cosmoses1239703cosmoses
cotinines11410073cotinines
coulisse1045113coulisse
coulisses1145633coulisses
counsel948543coun_sel
counsels1037573coun_sels
countess103710053countess
counties10316283counties
courses94218893co_urses
cowfishes2045723cowfishes
cowhides1736013cowhides
cowpies143314283cowpi_es
cowries124218013cowri_es
cowrites133011593cowrites
coyness1277323coynes_s
coynesses1437573coynesses
cozies174521413co_zi_es
coziness19319823coziness
crinites10612763crinites
crises84529433c__rises
cronies9622503croni_es
cruises93514443c_ruises
cullises103111313cullises
cutinises1148513cutinises
cutises94414913c_utises
cyanides14258003cyanides
cyanines132710543cyanines
cyanites132610163cyanites
cyanoses1337423cyanoses
dogfishes1745083dogfishes
doggies103613023doggi_es
dogies85022253dog_i_es
ebonises1039223ebonises
egises7312493_eg_ises
eonisms92811043eo_nisms
finises10312903_finises
fogies104118063fog_i_es
fogyisms1743283fogyisms
fornices1369103fornices
gnoses76515163__gnoses
goonies83618333gooni_es
guises74216313__guises
haggises1335883haggises
hogfishes1944683hogfishes
hognose11117243hognose_
hogties112813993hogti_es
hoises94823673ho__ises
hongies112716473hongi_es
hornists11208833hornists
ignites81310583_ignites
iodises83413633io_dises
ionise63516943io_nise_
ionised82911493io_nised
ionizes162813343io_nizes
joneses1438963jo_neses
koumises1444593koumises
kyanises15206393kyanises
lignites9129613lignites
lionises8310313lionises
logicises1256203logicises
loginess9310163loginess
longies82916553longi_es
loonies73919543looni_es
lorises73918593lo_rises
moggies113111723moggi_es
monies83233163mo_ni_es
monishes13311483mo_nishes
monisms113512803mo_nisms
monists93614783mo_nists
moonrises1146723moonrises
morrises10711073morrises
mortises10713613mortises
noesises838503noesises
noises65021853no__ises
nonuses73313863no_nuses
ogives10367913_og_ives
ogrisms1036443_ogrisms
onuses65616253_o_nuses
oogeneses1047853oogeneses
oogenies9311583oogeni_es
organises1048683organises
orrises71312233_orrises
ozonises1776373ozonises
paganises1239723paganises
penises9318193_penises
poetises10313953poetises
pogies94123543pog_i_es
poises84226543po__ises
ponies84833463po_ni_es
prognoses1247533prognoses
recognise1245303recognise_
recognised1444123recognised
recognizes2255573recognizes
romanises11311573romanises
sonnies7315223sonni_es
soubises10107993soubises
tennises82810133tennises
tonuses73612193to_nuses
toonies73719883tooni_es
townies103113623towni_es
womanises1448063womanises
zoonoses1746203zoonoses

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 Limit1461622556.64322002.4
3Display Results2552550.1062405.7
 (SQL Overall)1786912557.16924925.5
 
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.