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

115 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
cognized213629(None) 
cognised1256311cognised
cognize1957681cognize_
cognizer2055861cognizer
cognizes2058031cognizes
agnized18247222_agnized
agonized19258992agonized
cognise1059682cognise_
cognises11610042cognises
cognizers2164432cognizers
colonized212710432colonized
connived1436432connived
corniced1368592corniced
ionized172611292io_nized
recognized2345252recognized
agenized19257733agenized
agnize16329563_agnize_
agnizes17328843_agnizes
agonised10248483agonised
agonize172911403agonize_
agonizes182610583agonizes
botanized2147283botanized
canonized2147683canonized
caponized2347073caponized
capsized2255493capsized
cocainized2444643cocainized
coedited1237833coedited
coffined1735993coffined
cogged116416613cog__ged
cognate10312203cognate_
cognates11311583cognates
cognizant2144123cognizant
cognizing2247173cognizing
cognomen1346083cognomen
coifed124113063co__ifed
coigned11418663coign__ed
coiled95123943co__iled
coincided1544023coincided
coined94523603co__ined
cojoined1856293cojoined
collided12309803collided
collied103316673colli_ed
colonised12248723colonised
colonize192312773colonize_
colonizer20309283colonizer
colonizes202613183colonizes
colorized212211773colorized
combined15269183combined
commixed2264743commixed
communized2645283communized
compiled1537813compiled
comprized2567223comprized
coned86040053co_n__ed
confided1537453confided
confined14310403confined
congaed11399743co_ngaed
congeed113212313co_ngeed
conies84338593co_ni_es
conifer123212643co_nifer
conine84528553co_nine_
conines93827793co_nines
conked135019113co_n_ked
conned95119703co_n_ned
connive1238993connive_
conniver1337493conniver
connives1339723connives
connoted1138863connoted
copied114618563co_pi_ed
coppiced1734823coppiced
corned95224523corn__ed
cornered11311133cornered
cornfed1337383corn_fed
cornice11612933cornice_
cornices12713293cornices
cornier93017093corni_er
cornified1546623cornified
cornuted1137473cornuted
cosied94819883co_si_ed
counted103815803coun_ted
cowhided1843753cowhided
cozied184112153co_zi_ed
cutinized2146913cutinized
cyanided15254893cyanided
cyclized2544943cyclized
dognaped1343493dognaped
downsized2343413downsized
ebonized2036973ebonized
gorgonized2243933gorgonized
hogtied12226653hogti_ed
hominized2446853hominized
hongied12308163hongi_ed
honied104818393ho_ni_ed
ignited9137623_ignited
iodized18969163io_dized
ionised82911493io_nised
ionize154613873io_nize_
ionizer162310123io_nizer
ionizes162813343io_nizes
ironized1858203ironized
kyanized25224553kyanized
lionized1837023lionized
logicized2244993logicized
monied94319463mo_ni_ed
organized2047543organized
ozonized1745113ozonized
paganized2247163paganized
poetized2037983poetized
ponied94920703po_ni_ed
recognised1444123recognised
recognize2145673recognize_
recognizer2254453recognizer
recognizes2255573recognizes
romanized2149213romanized
sloganized2144113sloganized
womanized2447043womanized

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.453394461.4
2DLD Change Limit1461621156.42022766.7
3Display Results1151150.0462500.0
 (SQL Overall)1786911156.91925826.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.