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

125 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
cognised125631(None) 
cognise1059681cognise_
cognises11610041cognises
cognized2136291cognized
agonised10248482agonised
cognize1957682cognize_
cognizer2055862cognizer
cognizes2058032cognizes
colonised12248722colonised
connived1436432connived
corniced1368592corniced
ionised82911492io_nised
recognised1444122recognised
agnized18247223_agnized
agonise83112693agonise_
agonises92613163agonises
agonized19258993agonized
botanised1246393botanised
caddised13315893caddised
canonised1256713canonised
censed94016323c_en_sed
coedited1237833coedited
coexisted1944143coexisted
coffined1735993coffined
cogged116416613cog__ged
cognate10312203cognate_
cognates11311583cognates
cognising1347043cognising
cognizers2164433cognizers
cognomen1346083cognomen
coifed124113063co__ifed
coigned11418663coign__ed
coiled95123943co__iled
coincided1544023coincided
coined94523603co__ined
cojoined1856293cojoined
collided12309803collided
collied103316673colli_ed
colonise102514283colonise_
colonises112814013colonises
colonized212710433colonized
combined15269183combined
commixed2264743commixed
communised1744953communised
compiled1537813compiled
composed154612063composed
comprised1648053comprised
concise11314473concise_
conciser12310243conciser
coned86040053co_n__ed
confided1537453confided
confined14310403confined
confused1437033confused
congaed11399743co_ngaed
congeed113212313co_ngeed
congested1338673congested
conies84338593co_ni_es
conifer123212643co_nifer
conine84528553co_nine_
conines93827793co_nines
conioses10313313co_nioses
conked135019113co_n_ked
conned95119703co_n_ned
connive1238993connive_
conniver1337493conniver
connives1339723connives
connoted1138863connoted
consisted1238503consisted
contused1138443contused
copied114618563co_pi_ed
coppiced1734823coppiced
corned95224523corn__ed
cornered11311133cornered
cornfed1337383corn_fed
cornice11612933cornice_
cornices12713293cornices
cornier93017093corni_er
corniest102117303corniest
cornified1546623cornified
cornuses10310033cornuses
cornuted1137473cornuted
cosied94819883co_si_ed
counsel948543coun_sel
counted103815803coun_ted
coursed104113603co_ursed
cowhided1843753cowhided
cozied184112153co_zi_ed
cruised103710213c_ruised
cutinised1245913cutinised
cyanided15254893cyanided
cyanosed1444613cyanosed
dognaped1343493dognaped
ebonised1136043ebonised
guised84612173__guised
hognose11117243hognose_
hognoses12108133hognoses
hogtied12226653hogti_ed
hoised105117433ho__ised
hongied12308163hongi_ed
honied104818393ho_ni_ed
ignited9137623_ignited
iodised9329243io_dised
ionise63516943io_nise_
ionises72916433io_nises
ionized172611293io_nized
jonesed1536263jo_nesed
kyanised16214163kyanised
lionised946603lionised
logicised1343943logicised
monied94319463mo_ni_ed
monished1438133mo_nished
mortised1178743mortised
noised75416233no__ised
organised1146353organised
ozonised1853893ozonised
paganised1346623paganised
poetised1138523poetised
poised94918473po__ised
ponied94920703po_ni_ed
prognosed1344533prognosed
recognise1245303recognise_
recognises1345533recognises
recognized2345253recognized
romanised1247923romanised
womanised1545753womanised

Search took 9 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 Limit1461621258.19017846.4
3Display Results1251250.0631984.1
 (SQL Overall)1786911258.42321214.7
 
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.