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

126 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
cognation1231075(None) 
cognations1339591cognations
cognition1247011cognition
conation101420881co_nation
connation11314261connation
agnation9311722_agnation
carnation11312942carnation
cogitation13410082cogitation
cognitions1346042cognitions
collation11313992collation
conations111318902co_nations
connations12312942connations
coronation12412072coronation
crenation11412922crenation
donation91513782do_nation
rogation91612052rog_ation
zonation171410722zo_nation
adnation9310783_adnation
agnations10310033_agnations
carnations12311353carnations
caseation1199513caseation
cassation1197913cassation
catenation1249523catenation
cation83925503c___ation
caudation1269993caudation
causation1199523causation
cessation1176853cessation
chelation1439963chelation
ciliation111112493ciliation
citation10314363c_itation
clavation1447003clavation
coaction12310773co_action
coagulation1447273coagulation
coalition1148703coalition
coaptation1448343coaptation
cofunction1745253cofunction
cogeneration1546443cogeneration
cogitations1448903cogitations
cognate10312203cognat__e
cognately1543853cognately
cognates11311583cognat_es
cognitional1454273cognitional
cognitive1545483cognitive
coition9314313co__ition
collations12312853collations
coloration12913183coloration
combination17108803combination
commination171111643commination
commotion1576983commotion
compaction1846753compaction
companion1577683companion
conative131214623co_native
condition12411163condition
condonation1448853condonation
conflation15412083conflation
congelation14410343congelation
congestion1349043congestion
connection14410533connection
connexion1874603connexion
conniption1446273conniption
connotation1347983connotation
consignation15136313consignation
contagion1246993contagion
contain9315833co_ntai_n
cooption1288343co_option
copatron1246753co_patron
copulation141111953copulation
coronations13410703coronations
corotation12410973corotation
corrasion1146483corrasion
countian1048123coun_tian
creation102816513c_reation
cremation13511643cremation
crenations12511693crenations
damnation1238403damnation
darnation1039823darnation
domination13712373domination
donations101112353do_nations
dotation91412733do_tation
elongation1145353elongation
emanation11910783emanation
enation73419233__enation
foliation121110793foliation
formation1439423formation
foundation1443803foundation
gnathion1243443__gnathion
ignition946533_ignition
iodation9310383io_dation
iodination1159983iodination
legation92412933leg_ation
ligation92313093lig_ation
lobation102110553lo_bation
location102113913lo_cation
lunation8311923_lunation
migration12179703migration
monition10311723mo_nition
nation64322803___nation
negation92913023neg_ation
nomination12712103nomination
nonaction1149443no_naction
notation81414603no_tation
novation111710013no_vation
nunnation9126563nunnation
oblation1039863_oblation
oration71617713_o_ration
ovation101510023_o_vation
ozonation1845673ozonation
pagination1348993pagination
phonation1439393phonation
pinnation1138013pinnation
planation11310123planation
potation101716783po_tation
pronation11415703pronation
recognition1445203recognition
rogations101510823rog_ations
rotation81615453ro_tation
ruination9311273ruination
solation8916153so_lation
solvation1237773solvation
stagnation1145543stagnation
tarnation9310093tarnation
urination9312173urination
venation11513503_venation
vernation12311083vernation
vocation132311983vo_cation
zonations18139313zo_nations

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 Filter1786911486410.420425454.8
2DLD Change Limit1486411266.25023782.6
3Display Results1261260.0462739.1
 (SQL Overall)1786911266.71626606.8
 
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.