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

170 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
cognize195768(None) 
cognise1059681cognise
cognized2136291cognized
cognizer2055861cognizer
cognizes2058031cognizes
agnize16329562_agnize
agonize172911402agonize
cognate10312202cognate
cognised1256312cognised
cognises11610042cognises
cognizers2164432cognizers
colonize192312772colonize
conine84528552co_nine
connive1238992connive
cornice11612932cornice
ionize154613872io_nize
recognize2145672recognize
aconite9315473aco_nite
agenize172910153agenize
agnized18247223_agnized
agnizes17328843_agnizes
agonise83112693agonise
agonized19258993agonized
agonizes182610583agonizes
bogie89524103bog_i_e
bonnie85314853bonni_e
bonze165119353bo_n_ze
bornite9311183bornite
botanize1948753botanize
canine83826703c_anine
cannie83819363canni_e
canonize1959833canonize
caponize2139113caponize
capsize2037623capsize
carnie84421093carni_e
cocaine111315173cocaine
cocainize2245783cocainize
codeine103815033codeine
codrive1337653codrive
coenure968153coenure
coesite9713623coesite
cogging123513713cogging
cogito939203cog_ito
cognac1157273cogn_ac
cognacs1256043cognacs
cognates11311583cognates
cognitive1545483cognitive
cognizable2443393cognizable
cognizance2452783cognizance
cognizant2144123cognizant
cognizing2247173cognizing
cognomen1346083cognomen
coigne94612193coign__e
coigning1237173coigning
coinage10310553coinage
coincide1346493coincide
coining103920543coining
collide103214793collide
collie83621993colli_e
colonise102514283colonise
colonized212710433colonized
colonizer20309283colonizer
colonizes202613183colonizes
colorize192314203colorize
combine133014723combine
commie124215523commi_e
communize2446283communize
compile13312443compile
comprize2368733comprize
concise11314473concise
cone67256963co_n__e
confide13310203confide
confine12315583confine
conge85227593co_n_ge
congee96024473co_ngee
congii957363congi_i
congius103210073congius
coni65534803co_ni__
conic95329793co_ni_c
conics103920593co_nics
conies84338593co_nies
conifer123212643co_nifer
coniine9316803coniine
conin76232723co_ni_n
conines93827793co_nines
coning94331823co_ning
conins84327233co_nins
conium10415313co_nium
connate9315753connate
conning103718753conning
connived1436433connived
conniver1337493conniver
connives1339723connives
connote9311613connote
conte76633203co_n_te
cookie123716043cooki_e
coolie83821603cooli_e
coontie9311423coontie
cootie84223093cooti_e
coppice1537483coppice
corbie103618203corbi_e
cordite10315263cordite
corniced1368593corniced
cornices12713293cornices
corniche1575923corniche
cornicle1258783cornicle
cornier93017093cornier
cornify1536253cornify
cornily12410853cornily
corning103720123corning
cornute939643cornute
corrie83621223corri_e
corvine122113643corvine
cosie74728263co_si_e
cosine83823513co_sine
costive12312843costive
cotinine10311493cotinine
cowhide1636143cowhide
cowpie133511513cowpi_e
cowrie113814283cowri_e
cowrite123612683cowrite
cozie163519133co_zi_e
crinite9513633crinite
cutinize1948533cutinize
cyanide13298843cyanide
cyanine122911513cyanine
cyanite122710763cyanite
cyclize2345403cyclize
doggie93910893doggi_e
dogie75222793dog_i_e
doglike13207453doglike
downsize2144273downsize
ebonize1838153ebonize
fogie96719003fog_i_e
goonie73615563gooni_e
gorgonize2044723gorgonize
hoglike15157733hoglike
hognose11117243hognose
hogtie102711773hogti_e
hominize2248593hominize
ignite71410583_ignite
iodize164112593io_dize
ionise63516943io_nise
ionized172611293io_nized
ionizer162310123io_nizer
ionizes162813343io_nizes
ironize16610373ironize
kyanize23265343kyanize
lignite81310303lignite
lionize1668823lionize
loggie84011993loggi_e
logicize2046043logicize
loonie64216453looni_e
moggie103210103moggi_e
monie75631653mo_ni_e
ogive9379093_og_ive
organize1849093organize
ozonize1546293ozonize
paganize2048633paganize
poetize18310773poetize
recognise1245303recognise
recognized2345253recognized
recognizer2254453recognizer
recognizes2255573recognizes
romanize19311013romanize
sloganize1944593sloganize
toonie63617993tooni_e
townie93312303towni_e
vogie95116663vog_i_e
womanize2248163womanize

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 Filter1786911340270.393454684.5
2DLD Change Limit1340271706.00022337.8
3Display Results1701700.0632698.4
 (SQL Overall)1786911706.45627678.3
 
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.